And the thing is those local bars/restaurants often move out once there's no longer locals around. Tourist bars and restaurants move in, as is seen in several neighborhoods in Barcelona. Tourists feeling like they have the right to live in houses that the locals need is the issue, not tourism itself (at least for this specific one).
I still disagree that tourists add much to culture. Culture of an area is more than just a transient thing caused by people being on the street. It's the festivals, customs, etc of the people of the place. Tourists don't contribute to this in my opinion (except, perhaps, in negative ways when they stumble back to their AirBnB in a residential neighborhood waking up all the people who live there and who have to go to work tomorrow and leaving the area trashed).
Tourist do add a lot of culture. They are happy to be there and they add people on the street. They make socializing in local bars / restaurants more exciting.
I honestly can't see a negative.
Your prices are going up because it's New York. New York doesn't sleep but it's not the tourists. Buffalo is a great town. At night the downtown is empty at night. The drunk homeless are usually local.