Even leaving aside properly negative experiences where I felt like they were abusing their powers, I’ve never had a direct experience with them where they were even remotely competent.
On two occasions, while at high school, I was assaulted during the day near the school - on both occasions I told the police exactly who had done it (one had held a knife to my throat, and the second one had broken my jaw). On both occasions that was my last interaction with the police about the incident - they didn’t, as far as I’m aware, do a thing. I saw both attackers around the area in the time afterwards.
(as an afterword, both are dead now* and maybe that wouldn’t be the case either if the police had done, well, anything at all)
Another time I called them because I was being chased by a guy with a sledgehammer at 1am and I had managed to hide in someone’s driveway - they just never showed up. I waited about an hour, and couldn’t phone them back cos my battery was dead.
So they do an important job, and I daresay they do it well at big events, and have to face a lot of shit during their working day, but my direct experiences are all negative.
*nothing to do with me, obvs.