Metro Atlanta
I have been able to do this, I think 3 or 4 times over several years, and I found it to be a delightful way to meet someone who shares our interests. All but one time they were already naked as they let me into the room, something that I think is very fun.
One guy visited 3 times over the course of a year for a project he was a consultant on. He liked for us to go use the hotel hot tub for a while, then return to his room and have a drink and chat while we "air dried".
Unfortunately, security in more recent times means needing a room key to access some areas or to get the elevator to work, so at least in larger hotels the traveler would probably have to meet you in the lobby. And some prefer that as a safety measure anyway. But meeting someone from this site helps mitigate that a bit.
I'd encourage people to try it if they have the time when they're visiting a new place.