I'm not so sure if that's always going to be the case. Increased supply could very well turn San Francisco into cities like Hong Kong or New York - More houses but just as expensive.
If you think the current San Francisco as a small bucket full of water, will increase the size of the bucket stop the water from being full? well, that will depend on out how much water out there that wants to flow in right? If there are more water wants to come in than the size increase, you will just end up with a bigger bucket full of water.