Massively overpowered spells that can clear out a dungeon in one, amazing blast.
I would like something like this (for all classes) not just mages. But there has to be a trade off -yes the spell may be godly - but should have a severe physical toll on you. For balance purposes.
Like maybe you lose most of your life points, end up with say only 15 life points. You also lose all of your stamina, mana with regen being denied (including health regen) for full 60 seconds after the spell fully resolves. Mind you this is just an example of the cost & effect to maintain equilibrium.
These kinds of balances gives these powerful spells more purpose. More cerebral input of you of deciding "when to" and when "not to" use them.