Yes, but I'm an illusionist. I can't see how sneak would work with destruction, since you're discovered the second you cast the spell and there's no critical damage. Sounds more like classic kiting strategy than stealth.
+1
I have a level 75 character that's morphed into a lot of different things, but through the early game, it was a sneaky illusion mage with conjure as a backup. I have every perk in the illusion tree, and despite being overpowered, it's a huge amount of fun. Sneak into a room and cast frenzy at a group, then watch them beat the snot out of each other. With quiet casting, they'll never figure out where it came from. Eventually I got tired of the micromanaging of countless spells for different situations, and morphed into archery (and later, warrior skills), building those illusion skills was a complete blast.
In Oblivion, I used to make custom spells that combined things like Frenzy with Invisibility, and disappeared into the shadows after every encounter.