You've got it backwards. NIMBYs are the ones doing the forcing through government regulation. NIMBYs want to dictate what I can and can't build on my private property.
NIMBYs (the community and vast majority of single family homeowners) don’t want to see their neighborhoods overcrowded and changed completely by density, because they moved to such a neighborhood to get away from density. So they vote as a group to keep their neighborhoods nice low density places to live.
Meanwhile, YIMBY people in dense areas think they should have the final say over what SFR neighborhoods feel like and how they develop, even though they don’t even live there.
It’s never the other way around. No single family homeowner NIMBYs push back against another apartment building in an already dense area in the city nextdoor. Yet YIMBYs feel so strongly about controlling low density townships they don’t even live in that they advocate for state preemption. That preemption forces those places to change to adopt the YIMBY vision of walkability, density, public transport, and less cars, something few to none of the residents in that community want.
The closest thing neighborhoods have to votes on density are "town hall" style meetings where the crankiest asshole in the neighborhood shows up and pretends to speak for the entire neighborhood. And inevitably they're wrong, because there are always people that don't want to stay for whatever reason, and they rightfully want the highest price for their property, and that price is always going to be higher if they can sell to a developer which will build high density apartments in high demand locations.
Believe it or not, we actually do have a legal mechanism for entire neighborhoods to vote on density, and it actually has more power than zoning boards...it could prohibit density even where upzoning happens, because it can prohibit the density at the level of a deed covenant. They're called homeowners associations. They suck, and everybody hates them.
If Andreesen can't convince his neighborhood to form a homeowners association, and willingly introduce density-restricting covenants to their deeds, then you can be assured that density restrictions on zoning are actually minority rule...not some community decision.