I'm a rabid NIMBY, and I know that my house price will go UP when density increases.

I don't care. I want to live in my house, not sell it.

You're entitled to whatever policy preferences you might have (within reason, I guess; this housing position is within reason).

Whether your surrounding community should honor that preference is a different question. Depending on where you live, your preference, and even those of the consensus of incumbent residents, can be more or less persuasive.

If you live out in the middle of nowhere --- an exurb, say, with large lots and built around people who have consciously chosen to opt into long commutes and out of metro hub and metro county services --- your neighborhood's preference against density can indeed be somewhat compelling. Though I'd note that states are moving towards a directional consensus that local governments should not be able to impose single-family exclusionary zoning preferences no matter where you are. To that whole scenario: big shrug.

On the other hand, if you're in an inner ring suburb, the equation changes sharply. Your community likely siphons high-dollar tax checks out of the regional school system fabric and into a mostly economically homogenous enclave of concentrated opportunity. You'd benefit from close connectivity to the metro hub, short commutes, economic spillover, all while walling yourself off from the area.

In that scenario, it is reasonable (and probably the straightforward correct policy) to ignore your personal preferences, and to think about the preferences of the entire region and of the prospective future residents density would enable.

It all depends.

Props to you both for honesty and understanding the economics.