"Entirely too many areas of California are opposed to new housing developments because it's going to lower their property values. Period. End of story."
This explanation is commonly repeated, but it rings false, for a couple reasons.
One is that if you ever talk to a NIMBY boomer (or are related to one), you'll very rarely hear them talk about their home value, except in the context of lamenting how their kids can't live near them anymore. Instead, you'll hear them talk about how they'll lose their view if the high-rise goes up, or they'll be in shadow, or that it'll bring in the riff-raff, or the roads can't support more traffic, or how will the school systems cope, or it'll change the bucolic character of the town, or you won't be able to know your neighbors. It's all about preserving lifestyle, not money.
A second is that even if these are bullshit excuses for actually wanting money, their incentives don't add up. The worst NIMBYs are people who intend to die in their home and never move again. Economically, they shouldn't care about their home value, because by the time they can turn it into cash, they'll be dead. A lot of them are even childless, so the "leave an inheritance for the kids" argument doesn't apply.
A third reason is that development usually raises home values. 30 units on a half acre in the Bay Area goes for about $10M; 1 unit on a half acre in the Bay Area goes for about $3-4M. This is how developers profit, and how they can convince homeowners to sell to them in the first place. Upzone a 1/2 acre SFH and the homeowner can pocket a million or two over fair market value, and the developer pockets maybe $3M after construction costs.
A more likely explanation is to a.) take NIMBYs at their word when they say it's all about quality of life rather than finances and b.) understand that development privatizes gains among former and non-residents, socializes losses among current residents, and socializes gains among future residents. When a lot gets upzoned, the people who make a financial windfall are the developer (non-resident) and the seller (former resident). The people who enjoy a better quality of life are the new residents who move in and wouldn't otherwise have a home in a desirable community (future residents). The people who suffer a worse quality of life - for all the reasons listed above - are the existing homeowners (current residents). Guess who are the voters?