What ends up happening is that developers need to raise the rents on the non-subsidized units, because they're the ones that subsidize the subsidized ones. Which creates a constant upward pressure on housing prices that ends up squeezing everybody.
I'm not sure what the solution is, and I'm no economist, but it seems plausible. Looking at it from a 3,000 meter perspective, I would assume that, however well-intentioned San Francisco's housing policies were, we should probably expect that emulating them will yield the same outcomes that San Francisco is currently experiencing.
That's not to say that habitually segregating rich and poor people is a great idea, either. I would also suspect that emulating Detroit would also tend to lead to the sorts of outcomes that Detroit is currently experiencing.