However, I don’t think that’s the state or federal government’s responsibility to change. If American government is truly to be “of the people, by the people”, then the people’s decisions at the local government level ought to be respected, including letting them suffer the consequences of bad choices.
If anything, the local zoning issues should be fought via campaigns to persuade local voters of better approaches. Fight a bad idea with a better idea. Not every local policy problem should be fixed with a new law from the state or federal legislation, or with federal/state funding incentives.
The people voting NIMBY don't suffer any consequences though. VCs and big tech companies are happy to throw money away on higher salaries. Prop 13 keeps property taxes low for existing homeowners. The only people who actually suffer are those forced into homelessness and (to a lesser extent) those paying ever-higher rents for aging housing.