Bumping this thread because of Skyrim mods.
There's a magic mod that I'm really, really liking. It adds spells in all schools that can do damage, and also other useful spells.
ex: Restoration: Chanthrax Curse. Deals damage over time to the target it hits. If that target casts a spell, the curse spreads to nearby targets.
I.E. USE THIS ON MAGES.
Alteration has speed spells, and restoration has a sanctuary spell. It's absolutely perfect if you're a battle mage type character. A character who doesn't use many destruction spells, but god damn is that free 3 hit barrier and quick burst of speed useful when dealing with ranged enemies. Gets you right up there to pummel the assholes with your giant fucking mace without dying before you even get up to the enemy.
There's also dispel spells, which are neat if you're dealing with mages using mage armor. Personally, I REALLY wish they put these new spell types in to alchemy, too. Can you imagine a dispell poison? Those annoying mages with their mage armor abilities. Poison your blade with a dispell poison and OH SHIT he's completely defenseless now.
Also, stun spells. Teleport spells. etc etc
I guess the main reason I brought this back is because I really appreciate the level of intelligence and strategy this mod brings to the game.
I also appecaite the level of intelligence playing a non-tank character brings to the vanilla game. Dragons were kicking my ass because I can't use armor, or bows, and mage armor only goes so far ... and then it hit me. I'm buffing my alchemy ... why aren't I making resist fire/frost/shock/magic potions? And suddenly the game is balanced again.
So yeah. Things RPGs (ESPECIALLY RPGs like Skyrim) need more of: intelligent combat systems.
Which is why I love the Witcher 2.