Really, in general, any time you want a real "home base" you don't mind spending hours in if, say, some outdoor activity gets rained out, AirBnBs are far nicer than a hotel. Hanging out in a hotel room sucks, hanging out in an AirBnB can be like hanging out at home except... kinda better, in some cases and in some ways.

Or for any getaway kind of situation where the point is mainly to be at the place that you are staying, not necessarily to get out a ton. Hotels are terrible for that, aside, perhaps, from ultra-expensive huge suites (I wouldn't know, I've never tried one, too pricey and I have a suspicion it'd still feel like being in a hotel room).

They're also great in rural areas. Often you can get an AirBnB much closer to some 2nd- or 3rd-rate way-off-the-interstate attraction you're interested in, than a hotel. Otherwise your only options would be camping or an RV.

There are tons of professionally managed rental companies that have been in operation for decades where you can rent houses. Same price as the "internet" grifters without any bullshit whatsoever.