I think a better solution is exurbs where we have suburban clusters of low to medium density housing but centered around hubs in the middle of nowhere instead of radiating out of a major metro area.
This is much cheaper but still gives “culture” and community opportunity’s over pure rural life.
Telework makes this much more possible.