There's a lot of that, but the cheapest I've stayed at a Hilton in "recent" years the nightly rate was $59. My dad was at a group meeting at a local Hilton and they got a massive group rate with that hotel. And the cost of the electricity could be variable. One customer might just top off an EV at a local business meeting while others traveling long distances might be looking to fill 80% of capacity overnight.
One issue might be turnover since most Destination Chargers don't have idle fees (not sure how it works for the ones where the customer is charged although I'm thinking they're networked). But they're really more like home chargers anyways. Most customers at hotels are going to be guests staying there overnight. This would be different than the Destination Chargers at restaurants where it might just be an hour or two and there's likely turnover.
The only time I've ever used a Destination Charger was at Russian River Brewing in Windsor. I had to look around for it through. They had other chargers (not sure if they were free/subsidized) close to the entrance, but these were a good 150 feet away from the entrance and none were being used. I'm also not sure what the deal is now because Tesla says they require a minimum of six, but when I look at existing setups it's often just one or two. I think there were four at the RRBC.
Depending on the size of the hotel I think a time limit or notification to move the car would be the better way. You have guests coming in at all hours and leaving a car overnight to charge will take another person’s ability to charge up before morning.