"What it sounds like is the stereotypical upper-middle-class white suburban boogeyman of "Those People" that you don't want around, because they bring down property values, with a healthy helping of implied racism and explicit classism."

I don't know what it "sounds like" and I cannot speak to your stereotypes.

I no longer have any interaction with residential property, zoning, development, or any of these housing politics. I am not affected by "property values".

I look at these issues as an interested, outside observer and I have tremendous enthusiasm for urban spaces, walkable cities, mixed use environs, etc.

But at the same time I appreciate well regulated[1] single family neighborhoods/developments and while I don't live anywhere like that I appreciate the reasons that someone might have for preferring that.

I hope that it is useful and interesting to you to learn that there are a variety of practical and aesthetic reasons for (not agreeing with you) that come from ideas and experience that (aren't the stereotypes you have in mind).

[1] This is the correct term. Arguing for abolishment of residential zoning is arguing for deregulation.