OTOH it will provide more surveillance of the police themselves. Humans are also bad at gun detection (sometimes willfully so) and this provides another check.
Because it's a social problem, not a technology problem.
At the same time, just because these instances of "missing" tape happen, does not mean that body cams and jailhouse CCTV are useless. We would not take those away. Likewise for the future drone footage
It will absolutely happen in corrupt departments, or those involving an officer with those skills and access. But data that is uploaded is infinitely harder to erase than simply turning off the camera in the first place.