I think it has all been said before regarding sneak's overpoweredness. What I want is to find a way to have fun with it either by self-gimping or some creative character build.
Is sneak + destruction also overpowered once you get silent casting?
Surely the point of playing a sneaky character is to be able to sneak up on enemies and either kill or steal from them without them, or the "people" around them, knowing you were ever there. Why would you want to use sneak but not take it to its logical conclusion? From the game play perspective, even at 100 sneak with all the perks, there were times that I was detected (so its not like the chameleon in Oblivion) and if you avoid developing your archery too far, there is still a big challenge even with sneak maxed out (try working out how, with just a pair of daggers and your sneak ability, no ranged stuff and no magic, to take down half a dozen senior draugr milling round a big room).
Then when you have cracked that level of challenge, try taking Mjoll the Lioness along as your companion, it's an absolute hoot.
High sneak plus good archery, or other ranged combat, is just too easy.