I have a different, but related dream: for construction companies to be allowed to build anywhere they please, as long as they meet safety regulations. This way real estate prices in NYC, SF, etc, etc, will descend from the skies, and normal people from all over the country could move in. And move in they would, because that's where the jobs are. Only the damn high rent (and damn high cost of living) keeps them outside of the main metropolitan areas. And then we'd have exactly what you say, natural majesty flourish.
I am in favor of more density in San Francisco, but no matter how negatively we feel about nimbyism we must acknowledge that current blocks are tightly packed with single family homes or at best 2-3 unit buildings, and people live there. This creates an obstacle or delay if we think they should be demolished and replaced with denser housing.