When I was younger and not attached legally, I did a few overnights. Thing is they were all with one particular provider who is long retired. Each night was special as she would make the drive up to the foothills and we'd go out as a date.
She'd get the gawkers' gazes. I got the envious looks. Since I was always chivalrous and respectful so people must have thought that my manners made up for my lack of pretty much everything else. She'd use her thick Russian accent to politely ask me "(Kosh) Darling, could you be so kind..." and "Thank you, my lover" loud enough to cause a scene each time.
Dinner and a movie, bowling, whatever, those were almost 'real dates' except few real dates ended with such fantastic festivities - and breakfast!
As others have commented, it is a nice change of pace to allow the orgasmic be more organic with extended time. The connection can be awesome but alas, it's a bit of a dream.
Now overnights would be a hard thing to explain to the SO. I did do one overnight (outcall to my hotel) a few years back at a conference but it was not the same. I was from out of town and it was a first meeting, which was just 'ok'.
I would not recommend overnights without prior experiences.
ga_kosh