SF leads the nation in no one wanting to work in an office
sfgate.com
sfgate.com
It is not a dystopian hellhole like you are describing, it's not even as bad as the Tenderloin.
It is pretty bad, especially the underpasses even if it's not as bad as the worst place in SF (Tenderloin).