Yes, the police shooting "handcuffed" individuals in rare. The police shooting civilians in general is not:
https://www.theguardian.com/us-news/2015/jun/09/the-counted-...
> American police are killed in the line of duty, sometimes with no warning.
The largest percentage of which is traffic accidents. Between 27 (2013) up to 69 (2011) police were killed nationally in "felonious" circumstances per the FBI. Police shot and killed 987 or more people, but there's poor national data on this (the FBI doesn't track it).
So the police kill about 93% more people than they themselves are killed, and the 987 figure is considered fairly conservative.
> They really are here to 'Protect and Serve'.
Actually they aren't. The Supreme Court and appeals courts in "Warren v. District of Columbia", and "Town of Castle Rock v. Gonzales" ruled that they have no such legal duty[0][1].
> If you travel to the US, please do not fear violence from the police.
If that were true why are you offering people advice on avoiding police violence earlier in the post: "Even in a traffic stop, the key is to be polite and treat the police like human beings."
The "key" is to act a certain way to avoid a violent encounter but there's no concern about that in the US?
[0] https://en.wikipedia.org/wiki/Warren_v._District_of_Columbia [1] https://en.wikipedia.org/wiki/Town_of_Castle_Rock_v._Gonzale...