Although we have never had much space, we used to be quite happy to have people stay now and then or to stay with them. Nowadays we both absolutely hate it.
Part of the trouble is that as we have got older, so have our would-be guests, and it has become so much harder to share a small space.
Everyone takes a lot longer in the (only) bathroom than they used to and makes a lot more visits to it during the night, has become more fussy about things like mattresses and pillows, and less flexible about what they can / want to do during the day.
On top of that, we don't actually have a 'spare' bedroom - both OH and I sleep badly these days, so I use it myself. That way, if one of us is tossing and turning (or snoring), we don't keep the other awake. Not that would-be guests know this.
If someone stays, I have to share a bed with OH again and
both of us are likely to be extremely tired and irritable the next day through poor sleep. Best avoided if possible!!