I live in Seattle and the cops here are great. I find most big city cops don’t have the time or desire to hone their desire to own “their” streets. They just want to do the best job they can and go home in one piece.
I find it’s the cops with too much time on their hands that tend to be the ones that get too full of themselves. And you’re also correct about the small pay/small mind correlation.
I do wish that local governments would direct their police to solve crimes more than devise ways to employ them in revenue generating activities. That of course, is not a cop problem, that’s a legislature problem.
Note: Unless in military uniform, police officers are civilians.