With remote work, that becomes less of a problem
Not saying remote work doesn't expand the options - just that it isn't a panacea for all the issues that lead to expensive housing.
I've been fully remote for 10+ years and still only live in large metro areas mostly because I couldn't handle living in a large house in the middle of nowhere with nothing to do and no one to interact with.
Ironically it’s the well off office workers who are most likely to be able to work remote, the exact people who are least impacted by housing prices.