Unless the investor is willing to pay significantly more than a local family, this could deprive your heirs of money that they otherwise would have received.
Especially in a world of decreasing social trust, people are less likely to do something for the benefit of their neighbors or community and more likely to make purely selfish choices for themselves and their family.
"Who's outbidding you by tens of thousands of dollars for that home of your dreams? A hedge fund"
https://www.nbcnews.com/business/real-estate/who-s-outbiddin...
Research about declining social trust:
https://www.pewresearch.org/politics/2019/07/22/the-state-of...
https://www.pewresearch.org/short-reads/2019/07/22/key-findi...