I keep hearing Meteor Swarm and Fireball held out as uber-spells. They are not that great against BBEG non-minions. At mid-hi level you hit ubiquitous Magic Resistance, Fire Res/Immunity, Evasion, Saves, Legendary Auto-saves, plus the very real consequences of frying friends/treasure/McGuffins...