Only partially. You are correct that congregation does drive up prices. However congregation drives building more housing and other things which drives prices back down. SF has done less to drive prices back down than any other city and as a result has the most expensive housing. Eventually an equilibrium is reached (in practice this is false as things are always changing, but close enough)