I’ve worked away from home a lot in the past and have enjoyed it immensely, it was a hoot in my younger days. I have tended to get jobs in cities/countries I have wanted to visit. In hindsight it can be hugely damaging to relationships and family.
It is a very good idea to limit the hotel bar time, I’ve found the people in the hotel bar are in a similar situation to me – working away form home – and the conversations are generally similar. When away by myself I’ve explored the local area and sampled the local restaurants. Bike, walking shoes, computer have all helped pass the time. Getting out of the hotel is important for me as the room/hotel starts feeling a bit like a cell.
I don’t work away from home any more apart from the odd night very occasionally.