Yeah, I have. Worked just like it said it would for me.
Just make sure the place you're sleeping in isn't in a separate cell, I guess.
Yeah, I have used it for some time, and it definitely spices up sleeping outdoors.
One thing to be careful of though, is that if you sleep in Megaton (I sometimes camped outside Moira's) then if you get attacked the bodies do not seem to disappear!
In my current game the place has several corpses and a Mirelurk littering the walkway up to her shop.