My parents used to live in Orchard Park, NY, near Buffalo. They got SO tired of being tour guides to Niagara Falls, although my mother did enjoy it when I brought a guy from Italy, who was even excited over the stamp they put in his passport when we crossed into Canada at Rainbow Bridge.
They retired to Myrtle Beach but were always very gracious about taking in family. When DH and I were dating he stayed at a local hotel and Mom felt bad, till I told her we liked having a space for some "privacy". The subject did not come up again.
After we married, I spent the nights with DH in the hotel instead of with my parents. Even in their 80s, they welcomed everyone. My brother and SIL, AND two of their adult kids plus one spouse and 3-year old twins would show up- it was fine. (SIL was an excellent cook and my brother was handy around the house and liked to fix things.) The year before last, DS and DDIL came in from Des Moines with their 1-year old. They were to stay with my parents till DH and I got there, and we had a hotel room for them after that. Turned out they were having so much fun that neither Mom and Dad nor DS and DDIL wanted to use the hotel. We lost the deposit. I didn't care. Mom's gone now and I'm glad they had more time together.
This does remind me of a story in the London Times real estate section I read years ago (I always enjoy the paper when I'm there on a Sunday). The woman and her family bought a house in the south of France. They had an endless stream of visitors who would sleep late, wander in dripping beach water all over the hardwood floors, head for the wine rack and ask what was for dinner. The owners were exhausted and broke from continuous shopping, cooking and cleaning. They sold the house. They needed to learn to say no!