SF Housing is already dropping, but unfortunately it's so expensive that even a substantial drop of 10-20% would still leave it as one of the most expensive markets in the country.
The supply shortage is so severe that it would take a crushing local depression to balance out.