I don't care what type of game it is. MMO, RPG, ARPG. I love me some cool spell animations.
It will not come as a surprise, but my favorites were the DAoC wizard and Eldritch. Specifically the Void Eld, Fire and Ice Wizard and Thane
[disclaimer] not my videos. just some that I found online.