I don't mind a local AI on an airgapped security camera network monitoring a camera and issuing an alert to a security guard. The issues are internet connectivity, data retention/mining/sale, and non-local processing (ie handing stuff off to a third party that does who knows what and probably doesn't take security seriously).
I just watched Enemy of the State (late 1990s sequel to The Conversation [1974]) — one of the major plot elements is having to physically acquire the footage/tape (from isolated witnesses/cameras); whereas today, everything feeds into one central company [0].
[0] whom then repackages streams and sells to anybody — mostly law-enforcement — with no 4th Amendment protections ('cause it's a private company brah!).
Determining where the cameras are placed and what to alert on are also important and unresolved issues.
Simply getting alerts from a camera can cause people to believe that the area is a high-crime area, when it's merely a consequence of having a camera there.
Poor people are more like to be in public areas than rich pedophiles who can buy an island or ranch so they and their friends can enjoy wonderful secrets out of the eye of any Flock camera.
If the camera alerts on AI facial recognition for wanted criminals, and facial recognition causes disproportionally higher false alerts for people of south Asian heritage than of Anglo-Norman heritage, then systemic racism is built into the system, which we should all mind.
Even with that, I do mind.
Just as two trivial examples, even though neither affects me personally:
The estimated number of heroin users in the UK exceeds the total prison population. The number of class-A drug users in the UK is estimated to be so high that if they actually followed the minimum sentencing guidelines for possession, it would cause a catastrophic economic disaster both from all the people no longer working and also all of the people who suddenly had to build new prisons to hold them. I'm not interested in drugs (and I don't live in the UK, but I assume the UK isn't abnormal in this regard).
Another example is road traffic law. Even just speeding offences, I think you probably catch everyone who actually drives in the UK, often enough that after a month the only people left allowed to drive would be people like me who don't even own a car.
The entire legal system has to be radically changed with far less punishments for almost everything if you have perfect, or even 30% of the way to perfect, surveillance.