Wizards are interesting, but I've found classes like the Sorcerer to be more fun to play (in most settings.) Wizards do have their own aesthetic appeal, though. Transmuter wizards and illusion wizards would personally be my favourite. (I'm basing my opinion more off of DnD 3.5 than any other fantasy universe.)
Divine magic users are probably my favourite over arcane magic users.