I've watched numerous bodycam videos where people were told to do something to make themselves and the officers safer. They mostly show the ones that go bad. How often do you see a posted video where a person laid down the weapon and followed instructions? Rarely, because they rarely go bad.
Not saying there aren't screwups, because obviously there are. Amir Locke (https://www.youtube.com/watch?v=AWCpkPBKFR0) for example appears to be a terrible result of a poor practice, No knock warrants.
literally all of the videos in that search are coming from broadcast media sources. have you considered that police are also much less likely to release bodycam footage to the media if it portrays them in a negative light?
I've been watching https://www.youtube.com/c/PoliceActivity/videos (publisher of police body-cam deadly-force-used incident videos) for a long time, and from that sampling it seems that the number of police shootings (a significant proportion of which result in a non-police fatality) that can be reasonably labeled "suicide by cop" (or similar mental health related) is disturbingly high. A recurring scenario: 911 call of suspect brandishing a knife -> suspect charges responding police officers while brandishing the knife in an attacking manner and yelling "shoot me". Police policy and training clearly allows (supports) officers in this situation to shoot their attacker, and also clearly enables them to continue firing until there is no doubt that said attacker is absolutely no threat to anyone in the vicinity.
That's not data though, that's anecdotes. A handful of videos is hardly a fair sampling of a thousand incidents per year. The videos that percolate up are going to be the exceptional circumstances either way. Are there hard numbers you can point to that are published by folks other than the departments themselves?
Not saying there aren't screwups, because obviously there are. Amir Locke (https://www.youtube.com/watch?v=AWCpkPBKFR0) for example appears to be a terrible result of a poor practice, No knock warrants.
This one (https://www.youtube.com/watch?v=nQ1mo-ecOzI) is an example of not following direction.
There is no shortage of evidence if you look for it instead of having it spoon-fed by the media. https://www.youtube.com/results?search_query=cops+shoots