A better designed system could be driven by warrants issued by courts, without (or at least minimal) access to individual officers.

It requires better access controls.

Even invasive ideas like automated license plate scanning city-wide can have its data only accessible to an API to eg, track a stolen car across the city to avoid a dangerous high-speed chase in populated areas.

I think to throw the baby out with the bathwater around networked security cameras is failure around designing robust and secure APIs and systems (including audit trails).