Lmao idk if “most” even holds up in fiction. Even the “good” cops in fiction tend to perform illegal searches, abuse suspects, break the law in countless ways to get the bad guys. How many times have we seen the “good guys” stymied by their inability to search a home but one turns to the other and sarcastically says “oh I think I heard someone scream for help lol” kicks down the door?
Sometimes they have a conscience but I’d call very few fictional cops “good”