They're entirely avoidable. I live in central london, and I've never had any issues with neighbours until I moved to a flat where the landlord upstairs decided to just full-time airbnb the place, rather than rent to someone permanent.
Tourists are way more inconsiderate of neighbours. It makes sense - they're never going to meet us, they're just here to have fun. But pretending it has no impact on the quality of the area is silly.
> Tourists are way more inconsiderate of neighbours.
You cannot generalise. If tourists are making noises then there are anti social reporting services that you can use.
Airbnb is not only for tourists, but it is used by people who just moved in and are looking for a place to rent and don't want to spend fortune on hotels or for example it is a great alternative for contractors - having for example 1 month assignment, why spend money on hotel?
This is not my experience. Even in urban areas I've lived places that are not like this.