Me too! So relieved there are others who feel the same way about house-guests. I used to think it was lack of space when we lived in a small flat (I hated sharing a bathroom and having them sleep in living-room) but now we live in a house with a guest-room and guest-bathroom and I still find it stressful and overwhelming.
I love my friends but it's exhausting having them for a whole weekend. I can manage 2 nights but most people want to come for 3 nights or longer, and we had a couple earlier in the year who stayed 6nights!! DH is very sociable and extrovert and loves having guests. He thinks it's rude to ask guests which day they're leaving but I like to know the exact day and time so I can look forward to having the house to myself again 
I don't mind the preparation... I actually look forward to making the guest-room lovely and cosy, giving the house a deep-clean, getting special food in etc as long as it's not too often. I like cooking and trying out new recipes on people, and it's fun to do touristy stuff sometimes. I get pleasure from looking after people, putting fluffy towels and nice products in the guest-bathroom, arranging everything they might need. I just wish they wouldn't over-stay! One night would be ideal. 2 nights is tolerable. 3 nights I'm desperately wishing they'd leave. 4+ nights and DH and I start arguing (in whispers in bed) about why we have house-guests at all!! 
What I dislike is feeling 'on duty' all the time, not being able to relax, expected to be sociable and chatty and to entertain people 24/7. I don't like sharing my kitchen with guests and I hate people talking to me when I'm trying to prepare food. I also hate group breakfasts so I keep a stash of croissants in my bedroom, sneak into the kitchen early before they're up, make coffee and have breakfast in bedroom. Then I get showered, dressed and ready to start the day before facing them.
My favourite type of guests are those who are independent and relaxed, people who like to get up and make their own breakfast, who help load/unload the dishwasher, who go off on their own for a walk. I don't like needy guests who want constant attention or follow me around the house or insist on helping me cook when I've said no. Or those who want to play endless games of chess/scrabble/cards and insist we all watch films together.
I like it when DH's male friends visit without their wives, as DH is then responsible for entertaining them and I can dip in and out of socialising. They don't mind if I disappear to read my book for a few hours, and they take my word for it when I say I don't want help in the kitchen!!
My tips for coping with guests...
Put out breakfast things the night before (cereal, bread, cutlery, plates etc) and show them where the cold stuff is in the fridge and tell them to help themselves to breakfast as soon as they wake up. We still get some who wait for us but most take the hint!
Show them where the tea/coffee stuff is.
Try to pre-empt everything they might need or forget to bring. I hate trying to dig out spare toothbrushes late at night, rummage for aspirin or find extra bedding. And I dislike lending people my toiletries. So I always put a selection of pillows in the guest-room with an extra duvet, throw, lamp, bin, detachable blackout blind, hairdryer, extension for plug-socket, tissues, plus a drawer full of spare toiletries. I show them where the medicine-cabinet is and the spare keys to the front door, and write the wifi password on a bit of paper. And i make sure there are spare loo-rolls and towels in guest-bathroom. That way they can be self-sufficient.
Put leaflets re local attractions and maps of local walks somewhere accessible, to encourage them to go out for a bit!
If all else fails and I'm desperate for a break, I just say I have a headache and need to lie down for a few hours.