but being accused of sexual assault isn't always guilty of it.

Here we agree. I hope the Federal Government learns this truth regarding Supreme Court confirmations.

It isn't about public opinion.

It very often is. The officer in the Michael Brown shooting was clearly in the right given the facts of the investigation. But no one wants that guys name associated with their dept. In most of the high profile cases, the police were not wrong. But opinion matters, and very often they cannot work again. You can go ahead and list the one to three cases that you think proves rampant police misconduct, but these cases are truly very rare.

There are videos of police violence that demonstrates clear negligence and that directly causes peoples death.

I like how you said it isn’t about public opinion right before repeating what is often wrong with public opinion. Videos are one narrow perspective that often misses relevant facts leading up to an event or fails to catch what the cops on the ground are seeing. In some cases, video does show clear and damning evidence. In those cases police are charged.

Unfortunately, the state conducts its own investigation and finds itself not liable and thus these cases never go to court.

The state is not a single entity. It is not a cop investigating and clearing himself. While different states have different procedures, the investigation is conducted by an independent agency or sector. If you think our system is one of a unified government, watch 3 minutes of the news.

Honestly, police don't have to act the way they do in order to get the job done.

You are ignorant of what cops need to do to get the job done. Improved policing technologies is likely one of the many reasons for a general decline in violent crime. That is, prior to the slight uptick correlating to the Furgeson Effect.

it just takes a bit of humility and realises that the US isn't the best at everything in the world and there are things that can be improved.

One need not be have any particular opinion concerning the US to see through the bullshit narrative that claims black Americans are treated specifically poorly by police who are necessarily racist.

Our justice system most definitely needs improvement. Our violent culture needs to improve as well. Neither of these statements indicate a problem of racist policing. The data and highlighted cases indicate this is not one of our problems. In fact the only support for this narrative is the repeated emotional appeals designed to attract news story clicks and shoe sales.

But it’s true that being accused of sexual assault doesn’t mean you’re guilty (cough Kavanaugh cough cough).