As an expat Canadian living in a suburban county in the US, my personal interactions with the police here have always been cordial engagements as peacekeepers and caretakers of the community. I have called for welfare checks on neighbors, called the sheriff when I found a garage opener on the street, that kind of thing. Of course they were present in the aftermath of a case when a highschool kid entered a house and shot another highschool kid (who lived, surprisingly), a real shock in the sleepy community I live in. They asked around if anyone had video of the suspect approaching or departing the home.
But maybe that's just me, as a Canadian, with unrealistic beliefs that the police are on my side.