There's also the kind that bought into an area when it was already quite expensive, stretching their finances to do so, and are terrified of the idea of their home dropping in value due to density increases.

In reality, the kind of density increases that would actually meaningfully lower their home's value is well beyond what is required or feasible. But most people aren't economists or real estate experts, and don't know or believe this.