San Francisco's problems are the predictable result of inequality that's completely out of control. All US cities suffer the same problems as SF, and the only difference between them is a matter of degree.
The wealthy and powerful that created this problem would like to solve it while simultaneously continuing to exasperate it. It doesn’t take a genius to see that this will never work. At best, a temporary, politically palatable status quo can be achieved which is basically what US cities which are considered functional have.
San Francisco may recover or it might become the next Detroit. To some extent it doesn’t matter because without fundamental systemic changes it’s only a matter of time before the next city suffers the same fate.