I say, let the Chinese buy it all up.
The only catch is, they have to patrol the streets with Chinese cops. Mostly, because it would be entertaining to watch Chinese police deal with San Fran's looters, drug addicts, and thieves.
The Chinese have bought a lot of SF. Most of this was capital flight funds (anything to get assets out from under the Chinese government). But I think they have already lost a lot on money on their investments.
The current state of SF isnt going to attract more investment, from the Chinese or anyone else.
Note “the Chinese” arent a collective body. These investors are unconnected individuals. They have no organization. Certainly not the Chinese government, which wants to repatriate their assets.