As always the story has many angles but overall the trend is not good. There are parts of the city that used to be "just kind of sketchy" which now are basically un-walkable for the average person, especially those who don't know the city. You can't leave anything visible in your car otherwise you'll return to a vehicle with a lot more airflow. And it's clear the commercial occupancy rates haven't returned and may not for some time. None of this is particularly unique to SF, but a lot of things hit SF at once, which makes the incredibly high housing prices and rents just not palatable anymore.
It's still a great city and will surely return but the question is where is the bottom?