Sneak is only good for pickpocketing really. I use the rogue's stealth ability if I ever need to steal anything or pick locks while there are people around.