Our family had one in Wales for years.
We were treated fine by everyone in the village - the house had someone in it most weekends and all through summer and over christmas. All people who behaved nicely, used the local pub, shop, milk-lady (lady who sold milk from her house), garage etc.
The work we had done on it was done by local trades people, the carpenter who did a lot of work lived opposite and was the village undertaker, coffinmaker and carpenter. In the early years he also had use of most of the garden to grow veggies and that only stopped when he decided he was too old for such a big patch, and he put it back to lawn for us.
Parents sold it at well below market rate to a local family because they could afford to and because it was the right thing to do. SO what had been a fairly rough one bed cottage in dilapidated state with scrubland for garden, ended up being a three bed, more modernised home with nice garden/veg patch.
The cottage next door though was sold to a lady who refused to talk to the locals, put zero money in to the local economy, sold it to other outsiders and it is now an AirBnB.
It is worth keeping in mind... who sells these properties to outsiders for top whack, if not the locals? Few people will sell specifically to a local family/resident for lower than market rate if they can get more selling to someone else!