In my experience (albeit not SFBA), people tend to support development in the abstract while loathing any specific development that is currently ongoing or proposed in their own cities. It might have something to do with the sausagemaking aspects of getting municipal approval and the back-and-forth about who pays for which infrastructure upgrades.