Can't say for sure, I have only made a few friendships (and those that I have boil down to instagram follows and less than yearly verbal exchange)

Barcelona and places like that seem pretty annoyed at the tourism - I think this applies to many big coastal cities. I know a few villages in the Italian mountainside where the locals are still very welcoming of tourists. This might be because they know their financial dependence is more direct and tangible. In big cities this cause-effect probably seems more abstract to the locals.

Idk can't say for sure