lets see here...

Queen Brahne had an interesting death.

I liked Tellah's death.

General Leo was sad.

Gestahl's death rocked... kicked off a floating island mmm

Um, a sweet death occurs with Mog in FF6 if you take the gold hairpin and let him fall to his doom. That's always fun.

any character in FFT who dies... Teta, balbanes, etc. all done well

as far as the best deaths ever... um.. every death in the suikoden series.