The reason "the narrative" exists, I think, is that there's a widespread perception that regardless of the circumstances of the shooting -- even if the evidence clearly shows the police shot an unarmed victim in the back multiple times, for instance -- the police tend to get off on the grounds that they "felt threatened." This contributes to a feeling that the police are held to a lesser standard than non-police suspects, rather than the same standard.
People in minority communities around the U.S. have said for generations that the police abused them; I give that some serious credibility. Also, there is much more to abuse than killings; there are many reports on widespread abuses by police departments, such as Baltimore and New Orleans.
I will add that in at least some other countries police do their job and shoot hardly anyone; I think in Scotland it's on the order of one per decade.
If any of the people in this thread wish to have a go at that, try here: http://www.killedbypolice.net/kbp2018
Pick a year, note how many police shootings are listed there for that year, then generate 20 random numbers in the range [1, N] where N is the number of said shootings, and look at the corresponding killings. That should give some reasonable insights.
I can't say I blame would-be "good cop" cadets deciding not to join the force to be associated with these acts; the willingness to protect bad cops by leadership seems, from the outside, to mean the entire system is rotten and impossible to change from within.