You link does not support your claims. Shift Media is a business (ironically web dev) who lost their lease and moved - nobody lived there. The artist mentioned - who actually did lose her home - was living illegally in a warehouse. So unless you against enforcing zoning - not sure what we can do.

Live/work has been good for housing but way to small to have have an impact. Although I agree it did not live up to it's pro-artist hype. This was do to poor drafting (possibly intentionally or possibly just impossible - try defining "artist") by the SF BoS. Developers just followed the rules which were then changed a few years later. Similar thing happened in NYC at least twice (e.g. AIR in SOHO.

Today it is pretty much impossible for developers to build housing for low income people in SF without heavy subsidies. Land is just to expensive and building costs too high. Only huge easing of development regulations to make more buildable land available and costs lower would make a difference but you are against this as are most people in SF. So we should expect more of the same and the slow and steady gentrification will continue - it is totally predictable.