Your argument is not very clear to me. They may very correctly realize that when you take how large the demand is + how much land is up for sale + how much could possibly be built on it + which neighborhood they want to remain in... the chance the market will reduce those units to prices that affordable to them... the chances are very low. So its not really a surprise they become NIMBYs.
Yes, rent control distorts supply and demand, leading to higher prices.
Land will eventually constrain, but at the moment SFBA has tons and tons of unused air that is kept off the market by zoning.