I really like the magic in FFVIII the most.

Demi, Aura, Ultima, and Meteor are all favourites of mine.