The reason this doesn't work is that people want to live in very specific places. If you aggregate at the national level, the cost of land or housing hasn't gone up all that much in America over the last century. For every San Francisco there is a Detroit to balance things out.