Hotels are fine, if you can afford them. During COVID, when permitted, we visited our son and family in York and stayed in a hotel instead of with DDiL's mother.
For three nights, we do not like travelling after dark, so go up Friday, come back Monday, the bill was over £400. Yes, York is an historic town and popular with tourists, but we investigated hotels up to 20 miles away in Selby, and they was very little cheaper.
Heading north 4 times a year and the cost is heading towards £1,500. i doubt many of us can consider expenditure like that without considerable thought.
Having visitors, and staying with others has never bothered me. We will be staying with a friend overnight on Friday.
At one point I used to occasionally provide an extra bedroom for the B&B next door, for which I was paid. The B&B did the breakfast, I cannot fry eggs satisfactorily, probably because I do not like them and never eat them myself.