I've done this a number of times. Not so much recently, but years back. As long as the restraints aren't stretching you out (i.e. strenuous) and of course don't include steel handcuffs which can easily cut off circulation if you're not moving, overnight bondage can be fun. I loved the knowledge that I'd be there for a long time, and generally fell asleep turned on. Waking up later and realizing that you're still bound can be a huge rush.

The biggest problem with this though was that my domme would complain of getting less sleep because I would occasionally move and disturb her. I couldn't help it--just the result of being turned on and not being able to do anything about it. I think it ended up being more fun for me than for her, so play-time and bed-time are now separate.