From what I can remember, it worked pretty well if you're in full clunky heavy armour with a sneak skill in the negatives. It's not a replacement for a high sneak skill with perk points in that tree, but a big step up from walking around with a big neon sign pointing to your location all the time.
You'll also train your sneak skill more with this armour than you would otherwise because you keep trying to sneak.