The reason that I play Wizard in DnD is that you are versatile! Of course, I love to imagine my char casting lots of powerfull elemental spells doing tons of damage, but I love when you cast the Counterspell in the right enemy at the right time or change the field or put some wall or difficult terrain between your healer or friends that will protect them from a group of enemies that are coming in their direction.
I love the idea that you can be what the group needs you to be:
- If you need a damage dealer, you have one of the best! Single target or AoE!
- If you need a support, you have one! Shields, buffs, debuffs, counterspells, rituals...
- If you need a field controller, you damn hell have one! Freeze, sleep, walls (that give some damage or block), difficult terrain...
So, it would be nice to have a few of each kind of spell. Single target and AoE damage spells using elemental and arcane magic, some coontrol magic as freeze or sleep, some buffs and debuffs, short distance fast teleport, invisibility and some small shield preventing the Mage to die in 2 ou 3 hits.
A few summons would be nice, like the summons that Wizards have at DnD, that can do some damage or tank some damage.
Other important spells are portals and other non battle spells, like conjure something like food and water. I like those role playing stuff.
And please, for the love of God, take care with the casting animations!
Wizards/Mages in RPG don't usually jump doing some pirouettes or stunts while casting a spell! This is a total break for immersion.