Also, the beneficiaries of new housing construction are diffuse (if I want to move to Berkeley I want to have a choice of housing, but I'm not likely to go to community meetings to voice support for any particular project), while the opponents are concentrated (if I have a $2 million house right by BART in Berkeley, I have a very strong incentive to prevent new home construction near me, and I will definitely go to community meetings).
In a sense, this is a failure of democracy - there are parties whose voices are unheard but (arguably) deserve representation.
Even for people whose desires re: housing should be net neutral, it doesn't pan out. If I live in Berkeley but want to move to SF, I want to see SF build lots of homes and Berkeley to build none. But I can only vote in Berkeley, so my net voting behavior is anti-housing. Even if there is someone else in SF who wants the exact same thing but in reverse!