I hear ya OP, and for this reason I have NO-ONE at my house now - apart from adult DC (and their partners.) Even they stay 5 hours sometimes, (occasionally 6,) and it IS exhausting when you get to 4 hours. I glance over at DH when it's going into the 5th hour and I can see him flagging. I start to get backache, and my eyes feel heavy. And this is our own children! Sometimes they stay 3 hours, (which is fine, great!) but sometimes it is 4 or 5... They come about once every 4 weeks - and we go to theirs in between... So we see them maybe twice a month. Sometimes we go out for meals with them. Or the theatre.
My DH's cousin came from down South a few times a few years ago (when both DC lived at home.) He hadn't seen her for 30 years - and had reconnected on Genes Reunited. I didn't know her, and DH didn't really! He was about mid teens when they last met and she was 35 then, so she was 20 years older than him. He wasn't even close to her. So I don't know why he decided to ask her to visit. She wanted to stay with us but I vetoed it as we had no room and I didn't want a stranger in my house! So we booked her a Travelodge for the night.
The first time, she got here at 10.30am (We took her to check in at the Travelodge at 3pm,) and she stayed til 9pm. We were absolutely shattered. I don't know WHY she thought it was OK to stay 10 fucking HOURS. 
She came again a couple of months later and stayed 8 hours this time! I said to DH 'I can't do this again - it's so exhausting and stressful. I don't even know what to say to her. And she is rude and obnoxious!' It was a relief to get in the kitchen and cook for an hour to get away from her. She was critical too. Kept commenting on my weight, and our house, and our garden, and the area we lived in.
We went to visit her the next time - 2 months later - and we got there at midday. The plan was to stay til about 4pm. (She said we were having lunch at 1pm) She didn't give us 'lunch' til 3.30pm. We were STARVING. Hadn't eaten since 7am. She kept us there til 7pm. We kept trying to get away. She also seemed really offended and sniffy that we said we wouldn't stay at her house. 'I've made up the guest room' she said. It's got a double bed and sleeping bags for the kids. (They were young teenagers then!) We had booked a Travelodge too. 2 rooms. We said we don't want to waste the rooms.
We visited AGAIN 2 months later after she kept badgering us, and DH had to say he had work the next day, as she kept insisting we stay at hers!
She was so annoying that for a few months we started giving her a wide berth and not responding to her often. We went away for a week (to the Lake District) and when we came back, a neighbour told us that she had been to our house 'a number of times.' Maybe 6 or 7. (Over the weekend.) Just turned up on a Saturday morning - about 2 hours after we had left for our holiday! Random visit!
Why travel 200 miles and not tell the person you are visiting that you're coming? Apparently she kept popping back every few hours, and the next day too. Sent DH a letter saying she was disgusted that we pretended to not be in, and had clearly moved the car to give the illusion we weren't there.
Her reaction was farcical. She told us not to contact her again. Result!
As I said, we have no-one visiting now, (except our 2 adult DC and their partners,) and anyone else we meet on neutral ground! (Pub lunch/ coffee/ restaurant meal etc...) The vast majority of our extended families are either dead, or 100s, (or 1000s) of miles away... We very rarely see them. (Both sets of parents died some years ago.)
.