This is already a thing, it's called coffin cubicles or cage homes: https://www.theguardian.com/cities/gallery/2017/jun/07/boxed...
What I'm trying to say is: No, you should not lean towards this. You should lean towards jobs and opportunities spreading out over the country. To appeal to the HN population, instead of thinking in the binary thought of "SF (or some other tech hub) or fully remote!", consider another option: opening up smaller offices. Bring work where housing is affordable.