When my wife and I were buying our first house we had two houses taken out from under us because somebody came in with an all cash bid tens of thousands higher than ours. Both are still Airbnb’s.
This happens because hotel accommodation is generally overpriced. But if you tax the airbnb rentals, it deters profit-minded developers from engaging in this practice, while still allowing it as a last resort for homes that cannot be rented long-term and would otherwise sit empty.
House-Hotels managed by companies based in other states (sometimes even other countries!) don’t belong in residential neighborhoods. We have zoning for a reason.
If you mean that levying targeted taxes/fees to mitigate the bad side-effects of STR's has not been tried, I agree of course. I'm not denying that the detrimental side-effects exist.