I live in a Victorian in the Castro. There's a four (?) story housing project down the block. It's 100% fine. I understand not everyone feels that way, but we have a housing crisis, and housing people is more important than views.
I think it's going to be easier to build housing than to make network effects in industries not matter. You can just smear the companies across the country like they're butter.