I don't think I ever had an excellent rental experience. There is always something broken. Something not as advertised. Pictures are often deceiving. It is often difficult to deal with the host, as some are trying to make it their primary income and managing several properties. The chore lists are pathetic.
I would rather pay more and get a consistent experience from a hotel/resort.
This business need to be suffocated to death by local municipalities. Where I live, they just earmarked just over $1M to start tackling the problem. It's been illegal for a long time here but we have over 1500 illegal units operating in a town of 150k people.
FWIW, between my two sisters and my mother, they have 8 airbnb units. Love them dearly, want them to succeed, but nightly rentals are just contributing to the already fractured housing problem and it's only getting worse. We need to send a message that our homes we built for people to live in are indeed homes and not another financial instrument.
[0] https://www.independent.com/2023/04/26/santa-barbara-vows-to...
EDIT:
My brother and I were talking yesterday how govt probably won't solve the problem efficiently. We came up with the solution of a bounty program for ordinary people to collect the necessary info to turn in illegal op units and collect part of the fine assessed to the illegal operator. Self governing system.
We always travel with our kids, so multiple attached bedrooms is important, and something you pretty much cannot find in hotels without spending obscene amounts. Most hotels won't even guarantee consecutive rooms, let alone attached.