I'm not sure that Airbnb is the actual problem here, for me it was the host's expectation that people will just throw money at them whilst all they have to do is provide the location. The one half-decent place I stayed was, ironically, the only option without a hundred or so glowing reviews.
Alternatives to Airbnb exist for every niche and, in my opinion, you generally have a good idea of what you are going to get from the outset rather than with Airbnb where it is always a gamble - regardless of how much money you are willing to spend.
My favorite are Sun & Co (https://sun-and-co.com/) and Sende (https://www.sende.co/)
I've never had a perfect-five-star Airbnb experience either, but all my reviews have been very positive.
Airbnb guests and hosts need to get good reviews so there is an incentive to give better than real reviews in both ways.
One of the best ways to read reviews is looking for what reviews don't mention. Like no reviews mentioning the place is quiet or clean or having comfortable beds.
I would say I've had better experiences at Airbnbs attended by the property owner (like people who rent their extra room), than those attended by a co host or a subletting company. These are easier to find in non touristic destinations.
There's those that "game" the pictures so it looks nice and colorful, but have bad quality furniture and cheap dollar store everything. Those are better to avoid
Bob only needs to convince one person to stay at a time. That's it. And then it's relatively easy money. Especially considering that while the lodger is staying, you don't have to do hardly anything. You spend a couple of hours cleaning up after they leave, and that's it.
Hotels need to convince everyone to stay. True, while they can eat the cost of one or two lodgers, they can't become known as a place with bad lodging. Hotels have operating costs in the millions. They have staff, they're turning over rooms daily, cleaning every room daily, industrial HVAC, a bar, a restaurant (or two), sometimes a tiny convenience store, concierge services.
Hotels are invested in you having an acceptable stay.
Not going to lie, when travelling, I tend to gravitate towards national chains for lodging. While I'll never find the true wonders of the whatever of living like a local or what people claim AirBnB provides, I'll never have a truly shitty lodging experience either. It's one of the areas where I'm not looking to have an adventure.
It might make sense if you just need a place to crash after a long day of traveling, but it's not a way to live.
You just described living in a major city. Thats my life in my apartment in <Major West Coast City>.
I imagine it coming with a concierge app so you can add or remove stuff and the push of a button.
Look at it objectively: two people have to be able to make a profit off of you in this arrangement (the owner and their realtor) and both of those margins will be pretty fat since neither of them is a long-term employee of the other, like you'd see in an apartment complex with an on-site manager.
Real estate agents are always on the landowner's side. Just accept this and the whole system will make more sense (this goes for buying or selling a house too).