dtgreene: The problems I have with Pandemonium are as follows:
* Early/mid game: This spell can't be cast, as you're not yet level 14. While you can use it via Pandemonium Power, that item, like way too many of the consumables, is probably more expensive than it should be, and i would be better to sell it to get better equipment and/or spell books instead of actually using it.
* Late game: You can actually cast the spell. Problem is that, at this point, status ailments aren't as useful due to enemy resistance, and aren't that important because the game isn't that hard anymore at the point that you get access to Pandemonium as a spell. Furthermore, since this spell inflicts fear, it will make enemies run away, which tends to make battles drag on longer than they would otherwise.
Thing is, by the time you can cast Pandemonium, you are beyond the point in the game where there's a real risk of losing a battle, and are at the point where you want to win battles faster, and Pandemonium's fear effect makes battles take longer, which is the opposite of what you want at this point.
(Note that lower level spells that cause fear or blindness have their uses because you're still worried about the risk of losing a fight, so taking extra time to win isn't a big deal; by the time you can cast Pandemonium, there's little risk of loss, so prolonging a fight is not a good idea at this point.)
arnika_road: I see what you’re saying, although
1) Pandemonium Powder has singlehandedly saved parties in the low and mid levels. I remember a couple games where some random plants and bats joined in and I was surrounded. In ironman games I always had a dedicated throwing guy for stuff like pandemonium powder / ice bomb. Although admittedly I did sell some powders each game, I always had at least a few on hand
2) I do recall at least a few high level battles where Pandemonium, the spell, was more than useful. The battle with all the cultists and giant skeleton guys, the casters were feared allowing me to focus on the skeletons. Also there’s a huge battle near the end of the game with a ton of casters in the distance where it helped out.
The fact that they can’t be turned insane or charmed also makes them a pretty resilient support.
Is Psi amazing? No, but I never felt it was as bad of a class as people said, and Pandemonium always felt like a good safety net in case things ever went wrong.
There's other spells that can be useful in many of those situations at high levels:
* Freeze All, from the Wizard list, targets all enemies with a status ailment and doesn't have the same issue of prolonging the battle. Also, I note that this spell can work on undead.
* Psionic Blast, from the Psionic list: While it only hits a group, is a great spell for dealing with enemies that aren't close; it's the only damage spell that can hit through walls, not to mention that in can inflict insanity without a risk of inflicting fear and prolonging the fight.
* Quicksand, from the Alchemist list, can kill enemies outright. It and Resurrection are probably my favorite level 6 spells, and if possible, I always choose these spells first. (Might to Magic is a nice fun spell, but it ultimately isn't that useful, though at least it's better than Lifesteal.)
* Many of the spellcasting enemies, like Cultists, have low HP. If you can blast them with damage spells before they can put up a barrier, you can kill them before they can cast too many spells. Also, Eye for an Eye can cause them to be hit by their own spells, which can often end up killing (or disabling) them.
* If you can get Silence to work, you can force the cultists to charge at you, I believe, and they're easy pickings in melee. Unfortunately, I haven't found that spell to work that reliably. (Also, the Silent Lyres are too heavy for a spell that niche and low level, and why are there 2 of them?)
(Note that, of the spells listed, Bards can get access to Freeze All (and Freeze Flesh), Pandemonium, Lifesteal (which is decent on a bard considering the lack of good offensive instruments), Silence. Gadgeteers don't get access to any of these spells, but they do eventually get Asphxiate, but you might want to be careful with that gadget if you're playing Ironman.)
(Notice that my objections apply specifically to effects that can cause fear or blindness, like Pandemonium and the Prismic spells, not to Psionics, who still have some handy spells like Psionic Blast.)