Unless SF eliminates its insane height restrictions, the very few buildings that would be repurposed in this fashion would immediately become $4000 apartments.
It's a few drops in the bucket, yes -- but if we can't even bring ourselves to turn derelict buildings into housing, it's hard to claim that we're serious about solving the problem.