I used to really enjoy my overnights! I didnt get them often, but did have a few regulars who would treat themselves on a bi monthly basis. Some, we'd go out for dinner and have a great night. Some, we'd stay in the hotel and order all the luxuries. I only once had an overnight with a client I had never met before - he was in UK for work from Switzerland and kept commenting on just how cheap my rate was (I charged a flat 1k for a 10 hour outcall to the next major city!). After only 2 hours together, he fell asleep and didnt wake until it was time for me to go. I couldn't believe it! I did offer him some money back and I would leave since he was clearly going to sleep but he declined and insisted he wanted me to stay anyway. He has contacted me since for the same deal but our dates never matched but I'd swoop that up in a heartbeat.
I did have one truly awful overnight, which is one of the reasons I dont offer them anymore. The overnight was at my incall, with a client I had met twice before for shorter meetings. He was immigrating so wanted to treat himself before he went. What unfolded can only be described as a work nightmare. He wouldn't let me sleep. I pretended to sleep just to get away from him, he stroked and smelled my hair, kept trying to touch my private areas, moving closer to me in the bed as I tried to shuffle away then at one point I was clinging on to the edge of the mattress for dear life. The creepiest part of all was when he thought I was sleeping, I heard him walk about my apartment, opening and closing drawers etc., likely looking for personal items or info. I should have told him to leave there and then but it was about 3am, only 4 hours remaining so decided to see it out.
At 6am on the dot, he shook me "awake" and the horror continued. I was very glad to see the back of him.
I value my sleep slot these days so dont offer overnights, unless a very trusted regular asks me and I know I will be safe and comfortable in their company for that length of time.