As someone who grew up in a tourist area I support governments and communities that fight tooth and nail to not have a proliferation of tourism friendly housing (at the expense of the rental market no less) or allow other things that increase the market share of tourism relative to other local industries. When tourism is a large local industry it has tons of negative effects on the community that generally result in local government that doesn't have much reason to do a good job doing what it should do and plenty of reason to do things it shouldn't. It's bad in the short term that get made worse over generations.

edit: Yes I know I didn't provide any specific examples and that this viewpoint will be foreign to those of you who go somewhere for vacation and think it seems nice (yes, that's the point, to seem nice enough to get you to spend your money here, that doesn't mean it's actually nice or nice for the people that live there).