I've yet to use sneak, except once to try it out. Some people like firing arrows at tough opponents from sneak mode and withdrawing as they approach, in a hit and run tactic. The basic sneak skill should be good enough for that, though higher levels would probably help.