You missed the point and that is how do you know that wizard always has the rights spells memorized for every given circumstances. That is where all this I cast this and I win arguments fail. If the wizard didn't memorize evard black tentacles that or glitterdust and memorized something else instead then your examples fail.
Even if the wizard is expecting combat it does not mean he has the rights spells memorized so he gets an automatic win.
The problem here is that I'm mentioning mainline combat spells. Stinking Cloud, Glitterdust, and Evard's Black Tentacles are not niche spells. They are spells that happen to be my favourite mainline combat spells at levels 2, 3 and 4. And all of them are pretty flexible. All of them ignore spell resistance (and by extension spell immunity). Each of them has a very different counter (in some games I'd take Solid Fog rather than Evard's) so the enemy needs to prepare against them all. All of them can either with good positioning take out single targets, or can take out groups of enemies (glitterdust also counters invisibility for extra flexibility). All three spells therefore make it into my spellbook as general combat spells. At level 2 my rival to
Glitterdust is
Web (I need to hit Reflex with something debilitating, and it doesn't allow SR eitherm or even pay any attention to evasion). At level 3, my rival to
Stinking Cloud is
Slow - which is a multi-target anti-will spell to absolutely cripple melee enemies. And at level 4 my combat spells are
Evard's Black Tentacles (AoE anti small person spell),
Confusion (or
Fear if I banned enchantment) for an anti-will spell for upseting fighters, and
Solid Fog.
As a wizard,
my job is to be prepared for a range of problems on any given day. And becuase of the power and flexibility of the spells, memorising multiple copies of powerful and versatile combat spells is a good way to do this.
A default loadout expecting some trouble (but not actively dungeoncrawling) at level 7 would probably include two Evard's, two Stinking Clouds, and two Glitterdusts. This would leave me with room for Greater Invisibility at level 4, Fly and Haste at level 3, and Invisibility, Detect Thoughts, and Rope Trick at level 2. Plus my level 1 spells (probably Change Self, Alarm, Enlarge Person, Silent Image, and either Unseen Servant or Mage Armour depending whether I'm wearing a Mithral Twilight Chain Shirt or not).
Telling me I wouldn't have my wizard prepare mainline combat spells?
Why not? Why is the day such an odd one that I either don't have room for my favourite combat spells or don't know them despite having gained them automatically when I levelled?
The way you are talking I don't know why we are still playing this game or why everyone in the party does not play a wizard because according to you there is no way to challenge them and why bother playing anything else because you can't contribute. Why bother DMing just say oh hello wizard I can't beat you here is your XP for your automatic win.
There are plenty of ways to beat a wizard. The "Get a bigger hammer" method will do it. So will nickling and diming. At least until 9th level when the wizard gets teleport. So will a sudden ganking - a surprise Stinking Cloud will do just as much to the wizard as it would to the bad guys (CoDzilla naturally having good fortitude defences). Actually it's much harder to beat clerics or druids than wizards.
But high level DnD is an arm race the only way to avoid that is stop every character from gaining levels as long as DnD is a level based game it will always be an arm race.
Then you miss the arms race. When a fighter or barbarian gains a level, there are two obvious ways to challenge them. Bigger Monsters or Moar Monsters. The same fundamental approach works with a rogue, ranger, paladin, or any other martial class, and by a predictable amount. The wizard? What the wizard gains is more options. Which means more ways of subverting the problem. The wizard in 3.X gets to open completely different lines of attack with each spell level. At second level it's
Invisibility. At third it's
Flight. At fourth it's
Walls and
Animate Dead, sealing people off. At fifth it's
Teleport,
Polymorph, and
Permanency. Which means at fifth level a wizard can come from any point in any direction, looking like anything they want to and with an array of defences.
So greater dispel is not a I win and mathematically it works out to 50% but here again random factors play into it. I have seen the person casting it just wipe the floor and wipe out almost all the effects and I have also seem it completely and utterly fail. So again you don't know until you are at the table actually throwing the dice.
If greater dispel has a complete 100% success, what have you done? Traded a standard action for a standard action of an equally powerful wizard. The
best case scenario is that you've cancelled them out. Even if it succeeds you aren't making progress.
Note: This doesn't apply to throwing dispels at buff-monkeys. If the Cleric has Divine Favour, Divine Power, Righteous Might, Haste, Greater Magic Weapon, Magic Vestment, and the kitchen sink on them
What about summon monster you don't cast it and another spell in a round.
No. You cast it in one round. Then d4+1
Bralani show up and each of them casts Lightning Bolt both the round they turn up and the following round. That's d4+1 (small) lightning bolts in a round plus your other spells...
I've never seen a good 'all powerful wizard' that 'makes the game no fun for mundanes'. The people that make the claim never seem to want to stat out said awesome wizard. They just throw the 'wizards are too powerful bomb' and then run away.
In a previous thread I challenged people whether they thought there was a level 15 fighter who's as much use as d3+1 augmented
Celestial Dire Tigers, d4+2 augmented
Celestial Anklyosauri, or d4+2
Bralani Azata - each able to lightning bolt. Because that's what
Summon Monster 7 will get you. Or a single standard action from a
Summoner two levels lower who's lost his most important class feature (the Eidolon). And it's known that Summoners are good in PF - but not as good as Wizards or Clerics - there are enough duels to prove that.
And there have been enough arena duels involving fighters. It used to be quite the sport on the WoTC boards. The fighters lost there too above above about 6th level unless they won initiative and were able to one-shot the wizards. And the wizards weren't pre-buffed to be hard to get at.
Your challenge has been asked and answered. Many, many times.
As for no fun, that's the problem. Some of us
want to play wizards. And we're disappointed we can't.