The first two are outliers I'm pretty sure. All of my very best experiences with AirBnB have been of that kind, for what it's worth; VRBO is just as good for that, or at least, it used to be.
I suspect the last one is still pretty common, but/and AirBnB's meat and potatoes is short rentals in desirable neighborhoods of big cities, mostly tourist destinations.
Which is what hotels are for, and hotels don't jack up the housing market, cause problems for neighbors, and otherwise annoy the natives.
I must confess I've done my fair share of this, I was a 'digital nomad' for almost three years and it comes with the territory. I can confirm that the AirBnB experience for this use case has declined considerably relative to, say, 2014.