It's already been mentioned, but nothing beats Kefka IMO, he's the best villian and the final battle lived up to his reputation.
Chrono Trigger had a very good final boss as well, awesome looks, kick arse music, epic attacks and multiple forms.
Secret of Mana was pretty good as well, but I far prefered the penultimate boss, with his awesome music








