The stuff you had in morrowind.
a magic teleportation system
slow fall
levitate
lock doors
telekinesis to trip traps on doors
burden
feather
jump
swift swim
water walking
weakness
damage attribute
drain
night eye
sound
sanctuary
absorb
disintegrate
detect key
detect enchantment
detect animal
reflect
spell absorption
mark & recall
After seeing the stuff from Bethesda's own Dishonored and what some of the modders can to. I think the next TES can be beyond epic if they make better use of magic system.
HInt for lore friendlyness: Make the next TES society have properly institutionalised magical school that teaches kids magic at a very young age 5/6 years starting and ending in collage of magic and crafting and learning.