Freezing the SFH neighborhood also doesn't protect the community long term, as NIMBYs believe. When supply gets restricted, prices go up. It prices out the local teachers, service workers, aging family, and even the NIMBY's own children get priced out, until now it's just a neighborhood of million dollar+ SFHs with no young families, no local workforce. It's economic segregation.
Continuing to allow local vetoes and restrictive zoning just pushes us out further and further into unsustainable suburban sprawl, without the transit to match, and boosting emissions.
Not popular in individualistic America, but when we have the housing crisis we do, the needs of the many are going to have to take priority over the needs of the few NIMBYs.