Ok I will jump in on this thread, being one of those locals born and bred in an area which is deemed very desirable and visited by over 20 million tourists per year.
I firmly believe anyone can live anywhere they want but they have to accept more desirable areas will be more expensive - it is how society works, if every house was priced the same in every part of the country then you are in communism territory . Market forces will decide property prices.
I really enjoy that people not local want to live in such a beautiful place that I call home, if they move here to retire, or to setup a busy, or to work or for any reason that is great. I love my home and environment, it is a joy that others make a choice to come and share it, but some locals can be a little precious about being local and the area - people have different dispositions.
We accept that tourism is a huge economical benefit to the area but also it has its cons that the area can become busy and some visitors do not respect it as much as they should. For many who live here the tourists provide a source of income which locals fully appreciate.
I have friends, and family, who are of the mindset, which I think is wrong, that they have sold property to incomers, gaining the highest price possible but then complain their children cannot purchase property due to the high prices. They really do seem to think they can have it both ways. Yes there are more and more affordable homes being built new along with existing homes having s106 restrictions. This helps of course and does mean locals, or those who work here, so not necessarily born here, can purchase or rent at affordable prices.
Now what does annoy locals is those people who move here and then within 2 minutes of being here try and change things. We are not some backward yokels against change but we do expect people coming here to try and become part of the community, that sometimes means accepting things are not how you would like them to be.
Do not come to a valley where the majority of the locals livestock farm and tell them to eat less meat, do not tell them not to drive a 4x4 especially when it is that vehicle which is likely to be used for the rescue services and/or will help you out when the weather is bad, do not tell them they should not renovate and convert farm buildings to holiday lets as it will encourage more tourism. It is those type of incomers which cause a bad name for others and can lead to maybe the situation the OP is experiencing.
Life is for living, there are nice places in the UK and not so nice places, some people will always want to live in those nicer places and prices will reflect that.