I'm cautious around them, try to avoid calling them unless absolutely nessecary but aside from Hull Quebec/Montreal cops, the ones I've met have been mostly professional.
I even had guns pulled on me once by them once when I was living in Vancouver because they thought I was someone else (I still don't understand how a tall dark mocha colored cat like me can be mistaken for a black-ass kenyan manlet, but whatever) but at least afterwards they acknowledged their fuckup.
But every male member of my family has been prepped on the best ways to talk to and interface with them, so it helps I guess.
My biggest fear is if one my clients has an episode, or some of the kids at the group home gets a bit too ill and the cops have to be called, and there's a bad escalation because they aren't trained to deal with the issues some of these kids are dealing with. (Although on the two occasions it happened with my collegues they brought a mental health professional with them, so it's heartening to know there is an awareness towards that end.)
It is bit annoying how some people reflexively worship the uniform without assesing the person inside it, and how the police unions seem to lose all sense of integrity and self-control when one of their own is a provable fuckboi, but I suppose a likkle bit of overt reverence is good thing , maybe even nessecary for them to effectively fulfill their role in society. They are, for better ourt for worse, our "gunslingers".
In Canada there is a minor debate over how cops are elevated over the citizentry in terms of how they are valued. There was a mass shooting in Fredericton that claimed the lives of two cops and two civillians. There were some, including the relatives of one of the victims, who claimed that there was a disproportionate amaount of sympathy to the murdered police officers.
It's a touchy subject, but I think a murdered cop should be big deal.