95% of the time it is dropped. All you have is body cam and uncooperative witness statements, and a prosecutor realizes that with only that at trial they will lose, even if they are and know they are right to prosecute. Sad to say
the prosecutor will need much more, like you said, security cams, but then getting it and having it be admissible isnt an easy task for a prosecutor