When you are holidaying, you are looking for those little experiences that make every trip unique, and living in someone's home definitely adds to that.
But when you are traveling for work, anything that's not work is distracting. So one seeks 'familiarity', and that's where the experience of just getting back to a hotel with no surprises waiting wins.
It's the same reason I chose Starbucks to work from whenever I am traveling. I know I'll get the same environment, same mediocre coffee and similar wifi. No surprises, so I can GSD.