As an outsider, the solution to the SF housing issues seem pretty simple... Vote out the NIMBY politicians and replace them with people who will change zoning laws to allow for more building. I'd assume almost no one likes the current situation unless they are a landlord.
Complex problems often look simple from a distance. That doesn't mean they are.