So this question needs a serious answer. You can write something in the charter, but what's stopping enough people from changing the charter 30 years down the line? All NIMBY American cities started out as startups, the country's not that old. Little more than a century ago the West was associated with the frontier life.
So once people are in, ANY change is problematic. Increased density and construction is the common case these days because that's what we need, but the same would happen in reverse. If NYC's mayor said they were going to eminent domain the whole place to make it a low density suburb, even the people who get to keep their homes would lose their shit. You don't live in Manhattan because you want a big yard for your 6 dogs and 3 chickens.
When it comes to housing, any kind of change is hard. So if you start from scratch, there's not much problems.
I was admittedly heavily biased by where I lived before, because I am used to that area, which seems to be true of my friends, independent of where they actually work.
Maybe this is just the Bay area. For me at the time Palo Alto and Menlo Park were too expensive, so I was looking in Mountain View, Sunnyvale or Redwood City. Fortunately for me Mountain View has gotten a bit nicer in that time.
NIMBYs are likely not going to move a city built on the foundation of density and easy permitting. Just like people who hate hot climates don't move to Phoenix.
Build certain zoning policies into the city's charter that is hard to change. If NIMBYs move in, then - no, they don't get to change the charter with a simple majority.