the only instance I can think of that I know of is there as a historical black neighborhood near love field airport where Dallas changed the zoning to make redevelopment less profitable by requiring the houses take up less of the lot. This way developers can't build huge houses to offset the fact that the land is expensive or they can't build duplexes big enough to make them worth selling either. In fact there were a few duplexes going in to replace detached SFH and the developers were left in the lurch. I think even had to tear them down? I never followed up on the story. This was basically a policy to prevent gentrification by making the land less valuable by policy. Unfortunately gentrification and yimbyism seem like they go hand in hand because if you can develop bigger or more dense the property value goes up and people scream.
Where I can see regulation getting in the way is in the new codes. You can't build a house like you could in the 50s-70s anymore The code today is insanely expensive. Now those 70s houses weren't great. But they aren't didn't cost $200-300+/sqft at the low end.
in my view new single family housing can never be affordable because the cost is just so high. in fact. generic home ownership is as unaffordable as ever due to inflation. call a plumber to fix a leaky faucet? That will be $300. A new fence? $10k. A new HVAC system? $20k. A roof? $12k. These are all real costs for "small" homes. At least in the rental scenario the costs are controlled because not every single thing is a one-off. There are efficiencies at scale. If it's a housing rental company your maintenance guy is on a route, if it's an apartment you have building maintenance, etc.. The roof repair is a contract worth a million bucks where every roof is only $8000 instead of $12000.