Someone needs to tell the big developers. They keep turning out McMansions (and somehow selling them?).
There's no profit in building smaller.
My current place would sell for say $1.4M or so.
The lot itself is worth around $600-700k if it was empty.
A similarly sized home would cost well over $1m to construct to similar quality levels - normalizing a bit for modern construction techniques and all that.
So about $2.4m to build new, or $1.4m to buy a fairly similar 25 year old home next door. New construction here costs more than the older structures on the land in most cases. This ignores permitting and financing costs which throws a light wrench into those calculations, likely making it a bit more expensive on the build side.
That is using numbers I would pay a custom builder for, but even if you add in 20-30% profit for the builder the math isn't super great for the new build end of things.
For scale, in much of the country it is possible to build a new home for well under $200/sf. New detached homes retail for <$175/sf, which includes the builder's profit.
Not everyone wants a giant house, and plenty of people like a small one. It's not the size that matters, it's how you use it.
So when we talk about small and affordable we're talking more like 100 sq ft. Large compared to that is what most would call a modest home.
Housing prices are too high for most people to afford. That wasn't what the sentence I responded to was asking about.