Who says it's only about rent? People who live in a place for only a few nights in general behave very different than where they live for a longer time.
I live in a > 100 year old building with bad acoustic insulation with 10 small apartments in it. For some time, the tenant above rented his apartment via AirBnB which was totally annoying and I'm really happy it stopped.
I'm mostly talking about loud noise in the middle of the night, disturbing all the other tenants. Be it coming home drunk at 4am and puking in the stair case, having lots of parties, shouting, door slamming, etc.