But nothing with sneak. I never play mages in games, and would like to use some magic. Something that is fun and effective.

Not a pure mage, but try http://theskyrimblog.ning.com/group/character-building/forum/topics/character-build-bronze-sentinel

Dual Wielding Bound Swords, while relying on Alteration for Armor. This playstyle does not require a generous supply of Magicka, just wise Perk choices. Summons can be cast at quite a distance with Perks, and can be used as a Ranged Attack. Daedric Armor can be aquired earlier in the Game for a skilled Conjurer with the Atronach Forge at the College of Winterhold.

Summon Dremora Lords. Sip some Colovian Brandy while they mercilessly maim your enemies. Loot their corspes. Profit?