Morrowind is probably one of my favorites, but it definitely has not aged well. Going the mage route with custom spells can absolutely make you overpowered though. A single Damage Strength spell can cripple most enemies, as they become over encumbered by their few items in inventory.