Which is why most cop shows function as authoritarian propaganda. They show an idealist fairy tale version that nonetheless creates this aspirational image of cops in mainstream culture. It gives cover to the true cop culture. Just like villains in movies are always just a bad apple that is corrupt and once eliminated all is well, when in real world the rules of the system is what breeds corruption. It's not meant to be, but it acts as authoritarian propaganda.
I love cop shows, they are my guilty pleasure, but one needs to be aware that this is fairy tale.