Zoning rules like height restrictions, floor area ratio, lot coverage, setbacks, parking minimums, square footage minimums, lot size minimums, and other zoning restrictions place extreme limits what can be built before we even mention exclusive single family zoning.
There are lots of places all over the US, that have some forms of public housing.
And yet most people prefer private housing.
By all means, the government should compete in the housing market like everyone else.
And then the consumer should decided.
But, my feelings are that most people are currently choosing private housing markets for a reason.
Besides - even if there weren't many success stories to draw from, which there are - things can be improved on. Just because the first bicycles kinda sucked, doesn't mean that modern e-bikes aren't amazing. There are similar examples everywhere.
What's going on right now is a horror show. It's stupid, economically and morally.