Personally, I rarely use the poster-children for "Iconic" or "Overpowered" spells- in 30 years playing D&D, I've rarely had a spellcaster use Sleep or Magic Missile...and only one used Fireball (I prefer Lighting Bolt).
In fact, if you looked at my spell selections in PCs of past editions and put them in 3.X terms, most of my PCs would be Specialist mages of the Transmutation, Illusion, or Divination schools.
And yes, some are quite high level.
Find your theme and stick with it, but play the PC like he's intelligent- he does have a high Int, right? He'll be aware of the holes in his arcane prowess and take steps to mitigate them. That may mean doing a little multiclassing (divine spellcasting? fighting ability?) or spending money on magic items.
He may also accentuate his non-arcane strengths- a high-dex spellcaster may find proficiency with a ranged weapon allows him to hoard his spellpower for maximum effect and contribute even when his spells would be utterly useless. He's also going to have a good initiative roll- if his ranged attacks help soften up enemies before they get to his fighters, so much the better. (And, FYI, the Quiver of Ehlonna is cheap !)
In fact, if you looked at my spell selections in PCs of past editions and put them in 3.X terms, most of my PCs would be Specialist mages of the Transmutation, Illusion, or Divination schools.
And yes, some are quite high level.
Find your theme and stick with it, but play the PC like he's intelligent- he does have a high Int, right? He'll be aware of the holes in his arcane prowess and take steps to mitigate them. That may mean doing a little multiclassing (divine spellcasting? fighting ability?) or spending money on magic items.
He may also accentuate his non-arcane strengths- a high-dex spellcaster may find proficiency with a ranged weapon allows him to hoard his spellpower for maximum effect and contribute even when his spells would be utterly useless. He's also going to have a good initiative roll- if his ranged attacks help soften up enemies before they get to his fighters, so much the better. (And, FYI, the Quiver of Ehlonna is cheap !)