Hail Attack is a lower damage meteor shower that almost never hits anything (that's true) but when it does, it gets a freeze chance* and same for Chain Lightning, which when you cast rain before, is a massively effective crowd control spell (especially when your own guys are immune to stun) (Hail attack is super useful in the end-fight ,p)
Aside that, I agree..
The end-game spells are a bit uninspired too.
Geomancers for example, could have gotten a Golem Summon with massively boosted geomancer spells (epic versions of default spells)
Air mage could have gotten Ball of Lightning that shoots 3 or 4 giant balls of AOE lightning balls at the battlefield in arcs. Like the spore spell ;p
Water mages could have gotten magic that creates a ZONE (aka, blob) of water, that drowns enemies within, applies wet, and when lightning is applied further, creates a death zone deluxe. Where every move gets 4 or so triggers to apply stun/lightning damage...
I am also missing the simple and yet extremely awesome DnD like spells... like... Power word: Death , cloud-of-death. And exploding skull ;p But we can't have everything...