We are currently staying in one now. The only reasons I can afford it are, 1. I'm sharing a bed with my daughter, husband and son stayed home, and 2. I'm sharing with family , so the cost is split 3 ways. Otherwise it would have been £700 for 3 nights. Last Easter we went to France for around 1000 for all of us, for a week.
As a family we prefer a holiday home if it's for more than a couple.of nights. My kids are teens so definitely need their own room (s), we like to explore the local area to eat out etc, but balance by cooking at the home some days. For shorter stays it's hotels, I like the luxury.
Having grown up and still work in a tourist area, it's difficult to get the balance. We need tourists, we need staff. I think the real issue comes when 2nd homes stand empty for 50 weeks of the year. Which many do. Those home owners do not contribute to the local economy, unless they're having extensive building work done. But even then they often bring big teams from elsewhere. It's been a problem for all of my life and I'm 46.
And, as other people have pointed out, the holiday home owners have to remember we are on holiday. We came away to get away from the cleaning etc. If you can't get a cleaner, do it yourself, don't expect your guests to do it!
Gosh, I've too much to say on this!