Owners of SFHs tend to be the most stiff resistance despite the fact that upzoning increases the value of their land.

This is a culture war first and foremost. It's racism, classism, and fear of the unknown.