I always thought fictional law enforcement personnel operate on a case by case basis based on how likely are they to be shot by their own department

Like Leon Kennedy, had Racoon City not happened, would 100% get shot in the back by his fellow officers within a year for not being enough of a PoS