I agree that mages shouldn't be shooting of lil dime sized fireballs and such. .It's magic.
If you want a better explanation as to why magic should be strong don't look at me, I'm too lazy and someone else could/would explain it 10x better.
HERE WE GO: So the point of this is that people(just people that play the game) seem quite angry at some magic. Some of them have been removed from previous games, some are still in. I only really hear people complain that they don't want the ones that have been removed to be added, as the are "Over-Powered".
There are some magics that haven't been removed in previous games and that are likely to still be in Skyrim.
Some of these OP spells that I can think of atm are: "Command", "Drain Attribute", "Invisible", "Chameleon", "Paralyze", "Frenzy"
Some other spells that could easily be OP(some make skills/items useless): "Open", "Fortify Skill", "Fortify Attribute", "Calm", "Feather", "Shield", -Conjuration-, "Charm", "Silence", "Cure Poison", "Cure Disease",
Don't want to fight? Command any(as many) creatures/people. Turn Invisible. Frenzy them all. Conjure a pet, run. Paralyze, run. Drain Speed/Fatigue/other so they are either too slow or fall to the ground. etc etc
Want to get somewhere quicker than others? Turn Invisible(skip any/every foe). Fortify a skill/stat to make you run quicker, use while Invisible to make it even quicker. Use the "Don't Fight" spells. etc
Don't want to worry about needing to repair in the middle of something or want to have repair bills? Conjure Armor/Weapons. Use a shield spell to be as strong/stronger than someone in Heavy Armor.
Don't want to raise a skill/stat, but still want all the benefits? Learn "Open" spells so you are quicker than any Lockpicker, so you don't have to carry/worry about any lockpicks, don't have to raise another skill. <- Same with other Fortify skills/stats, Calm, Charm, etc. .
There are MANY other examples, many are probably better too. There is a chance some of these won't be in, some may be redesigned, etc. .
LET'S TALK!
As said before:
Feel free to ask other questions, as many people will find these stupid/boring.
Also, I know this won't change anything and is probably put together poorly.