I'm not a fan (at all) of the NIMBYism but I do understand it. What would you do if you had millions of dollars tied up in your home? If your home was your only asset of value? Especially if you bought a home in the last few years at top market value? You would fight against new housing which would deprecate your value(and rents) too.
I think it is selfish - especially to our children and grandchildren that will never be able to live in SF and/or the bay area, but CA (or more accurately the bay area) asked for this and it will be hard to turn back :( Judging by reports such as this ( http://lao.ca.gov/LAOEconTax/Article/Detail/265?platform=hoo... ) it will just mean the middle class will be gone soon and this will be the land of the rich only...
This is not wholly unique to the bay - almost every city does this. They champion rising home prices as great and then complain when they are too high b/c they didn't build to keep up with demand. Oh and also blame the techies b/c that is the cool thing to do.