I said aside from a role perspective, everything you listed (and I disagree with your opinion on what a unique spell is) is based on a role perspective.
Very well since you refuse to respond to it.
Health drain, str drain...drain ect... Super effective little magicka costing touch spell
Oh and the broken enchantment system that went with it. where you could do all that on strike.
To put it simply it'd be dumb not to use it if it's available as the ugly man in the store wisely proclaimed, we choose the path of least resistance. Even if we want to play the game on extream difficulty we will choose to fully use the resources given to us, and while it might take forever to kill the creatures with the right spell making you could just let hoards of enemies attack without a care in the world. This is what is called broken.
I didn't use such spells. Just because people can't control themselves doesn't mean they should scrap it.
Not to mention there are better ways to "fix" magic. For one they could simply balance those spells, they broke them.
Besides, why on earth do you choose to play such boring spells? Gotta play your game to the max? Go play an action game.
You play a game for fun, not because you found a way to exploit the game.
You should really go hate on spell scrolls because they had the duplication glitch, not to mention bows. We should remove bows and spell scrolls, because people can't stop themselves from duping weapons. Why fix your sword when you can duplicate 50 of them, and just replace it when it gets broken?
And NPC's, because you could kill that NPC in Talos Plaza and keep taking money, or maybe its gold that should be removed?
If people choose to play a broken game, thats there problem. This is just like all of the people who moded doom for infinite ammo, then complained about how boring it got.
If you don't want to ruin your experience, use a spell that is fun to use. My favorite spell was weak fireball, that wasn't a big end game killer...
Just simplify the game all because some people can't handle responsibility...