When I did contract work across Canada I would live in a hotel room from 4 weeks at a time, then had a 2 week turn around at home (my parents). Honestly it was pretty fun and I'm glad I took that job, but I probably wouldn't volunteer for it again. I was always much more outgoing and open minded in the hotels, making friends with the staff, exploring a new city, and going out with co-workers in the evenings, now living in a house I rarely ever make it to the end of the block and hardly even see the neighbours.
There were lots of downsides though; lots of co-workers would drink like fish, both in their rooms during the day and then at the nearest bar at night, I was no saint either but one guy had a habit of showing up to work sites with a good buzz on. You also get exposed to some darker parts of peoples lives, I had a guy pull a gun on the person staying in the room across from me, lots of pushy sex workers and their pimps, lots of vomiting (never park beneath balconies at a hotel). The only time I requested to be pulled off a job was in Calgary during the Stampede, the only accommodations available was a cheap motor inn on the highway, and I was in a room next to a coke dealer. He was an ok presence during the day, but at night he would be pretty tweaked out.