I have done two over-nights, the first with a regular who I took to a rolling stones concert and an over-night stay was pretty much essential, I bought the tickets she provided the sex. It was a great deal for both of us.
Second was a paid for deal with a girl from northern angels, can't remember how much it cost, we had a fuck in the hotel and went out for something to eat, finished up outrageously drunk, no idea how many times I fucked her after that, but it was a lot! Was it worth it? NO when you add up her charges the 5* hotel, top restaurant and all the booze it cost me well over a grand and all for a drunken fuck I can't remember.