It's very complicated. People have conflicting ideas - one the one hand, they want affordable housing (ie their rent to go down) or the other, not in my backyard.
Worth a view The Insane Battle To Sabotage a New Apartment Building Explains San Francisco's Housing Crisis https://www.youtube.com/watch?v=ExgxwKnH8y4