How would staying in an Airbnb give you any insight? The problem isn't the hosts, it's the folks staying. They're substantially more likely to be drunk and partying, and don't need to worry about any long term consequences of their antisocial behaviour.

I check Airbnb when I move, and I'd rate a full time rental next to me similarly to a busy street. Not a deal breaker, but certainly a strike against it. If others do the same, that translates to a direct reduction in property value for the host's neighbours.

I don't have any moral issue with Airbnb hosts or travellers - I have used it about as much as you have. I don't mind people making money from it.

But when a city decides to quantify the externalities and impose restrictions, it is absolutely not appropriate to talk about financial losses hosts have. They made a cynical bet on relaxed (poor) governance, and lost. You or I shouldn't care any more than they should care about my startup failing.