In some ways it's similar to the tourism or gentrification problem - the very things that make a place desirable lead to the destruction of those things. Some people view the world through a purely economic lens and treat individual people as abstracted production/consumption units. And unfortunately there's no real way to put a dollar value on "all the neighbors know each other and help each other out". And even if you could - you can't just BUY your way into that, no matter how much money you have! The only way to unlock that value is to live there and engage with the community. Obviously there will be turnover but what some people don't seem to grasp is that there is a tipping point, where enough newcomers overwhelm the "old timers" and destroy the culture of a place. And think about the game theory of it from the point of view of a resident - why invest time and resources in a community if you're just going to leave in a year or two? Or if the beneficiaries are future random people who are not going to give a shit about the community?

https://www.paulgraham.com/organic.html

Imagine that you were in a big meeting and you wanted an excuse to leave, so you whispered to your co-worker "Do you think my phone can receive messages in this room?" And he replied "Phones are the foundation of modern telecommunication infrastructure and we're in a large city, I assure you that you will promptly receive any messages that are sent to you."

Anyway - yes there is a ton of content out there, more than enough for 100 lifetimes. If you have two hours and eighteen minutes the movie Master And Command: Far Side of the World does the source material good justice and is an excellent film in its own right. It's quite true to the books so it is probably a good predictor of whether you'd enjoy the books.