My experience with the SFPD was very different — I'm sorry you had such disappointing experiences.
The first time I called 911 was when a man coming down from drugs tried to kick in my fire escape window. Four police were in my apartment within five minutes; they arrested and handcuffed the man. I couldn't have been more thankful.
My second interaction with the police occurred when I was punched in the face a couple of times while riding a Muni bus (San Francisco Mass Transit). The driver pulled the bus over while me & two other passengers held the guy until the police showed up (within minutes). Again, the police detained the gentleman who had punched me in the face.
Whenever I've needed the police, they've been there.