Anecdotally, I have SF colleagues who surprisingly often have to interrupt phone calls to check on disturbances outside. Filing a police report does nothing even for battery.
I'm still amazed by this Greater LA story where a vagrant has holed up on a woman's front porch, and the police won't do anything.
[0] https://abc7.com/van-nuys-los-angeles-homeless-man-porch-tak...