Eh, I'd say I've met quite a lot of long-term residents of San Francisco. Pretty much no correlation between ownership and how worthless that person is to the community. I know renters with their 30-year lease that don't even live here anymore. I know homeowners with their 30-year old property tax assessment that also don't even live here anymore.
Both just pop in every now and then to enjoy the Bay Area for cheap and then let the home sit vacant the other 300+ days of the year.
I also know renters and owners that have been very active in their local communities.
If the metric you care about is "societal productivity" there are better ways to measure and reward that than based on "how long have you owned here."