It's not unlike upper atmosphere pollution, as if every local community were able to have their own policy on it. The cost of pollution is paid for by no one in particular but principally other people far away. Each community's individual impact is tiny and easy to deny, but they all tend to choose the same thing which has a greater collective impact. Aren't their rights to choose more important than any cost to society, without question?
There is an amount of money that an individual can spend to buy a house in Palo Alto. That amount of money might be higher than some people would prefer or elect, or (in many cases) even be able to spend, but there are practical alternatives in any case (to include living in other communities).
In a case where no practical alternatives exist, I agree there's a much greater cause for collective input and decision-making (to include at a global scale in many cases, as these aren't even a state or nation-state level of issue, though it's the states and nation-states that enact policies and laws to implement/enforce collectively-agreed treaties on some of these topics).
Where practical alternatives exist, I find the most local government level to be the most desirable one to make the decisions that disproportionately affect the people who live there over people who don't live there but might like to.
That means I would consistently vote against them in my own community, but I still support the rights of people in other communities to make choices different than my own. If they prefer the outcomes under rent control or Prop-13 type initiatives, who am I to say that they're wrong for their own community? Of course I can have an opinion that they're wrong, but I'd rather not force them to comply with my opinion over their own and their neighbors'.
Side note: the reason I don't live in Silicon Valley right now is that when I went interviewing out there and had job offers from two companies at a healthy increase over my then-salary, neither would allow me to afford to purchase a comparable level of housing and lifestyle to what I have out here. That was in 1998 or 1999.