There are free government and non-profit social counseling services where people help you figure out what job you can do. There's also reddit and your friends/family for easier non-professional advice.
However, I think it's completely fine that you stayed in SF and made progress there.
As for your claim that you could earn some money in SF and not elsewhere - that's the core of my argument. My point being that San Francisco has more opportunity than pretty much anywhere else in the world. That you specifically could make money in SF, but not elsewhere.
No doubt that earning much less than plenty of other SF residents can have an emotional impact and make it look like your life isn't going so great. It's just that when you look at the US as a whole, or the world as a whole - then SF starts looking like a fountain of opportunity.
However, I think it's completely fine that you stayed in SF and made progress there.
As for your claim that you could earn some money in SF and not elsewhere - that's the core of my argument. My point being that San Francisco has more opportunity than pretty much anywhere else in the world. That you specifically could make money in SF, but not elsewhere.
No doubt that earning much less than plenty of other SF residents can have an emotional impact and make it look like your life isn't going so great. It's just that when you look at the US as a whole, or the world as a whole - then SF starts looking like a fountain of opportunity.