Are there any privacy-first security camera provider where it's the city that manages data access and uses it purely for local law enforcement purposes?
Why would you trust the city more than Flock. One of the common claimed abuses of Flock data is city cops using it to stalk exes and crushes. The problem with Flock is not who owns the data, it's the potential for abuse.
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).