edit: candidates may run on new housing development as it easy an easy thing to say and run on. But when rubber meets the road, local planning boards and strict zoning requirements mean translate into orders of magnitude less development than people would like or the market would have.
there are both city wide studies and the specific examples like the infamous laundromat or garage-door based house that are deemed too historic or architecturally significant (standards that would not hold up else anywhere in the nation)
for info on the two examples, google "Largent House" or "SF Mission Laundromat redevelopment"
As for what people want... is there any good way to be run out of town because you don’t have money? Unrestricted development wouldn’t address the needs of current residents at all and would result in people being forced out in addition to creating more homeless.