Yeah... no. Not all cities are equal - as the crime stats you just ignored show.
I just moved from Manhattan to Brooklyn - it's not the same as Manhattan, but I still feel safer in Brooklyn than in SF.
And you say "avoiding the tenderloin even during the day is common sense" - it's not the Bronx, it's in the middle of town. Make a left from a $400/night hotel room and you're standing next to human feces and needles.
That would be like if I told NYC visitors to "avoid midtown west in Manhattan, it's just common sense."
But you know what is interesting - you would've gotten that advice in NYC in 1985. Times Square wasn't safe. Now it's a shithole of a different variety - but a safe one.
SF doesn't need to be the way it is.