The cheap system I have with a Google Coral and FOSS software
I'm guessing you're using Frigate?
Having such systems as a later if defense is good. As the only defense, not so much.
Agreed. The system I had developed was built explicitly as a human-in-the-loop system. It never made any decisions on its own. It was just a tool to enable the existing security staff to have better visibility. That's it.
You can make whatever argument you want about viability and efficacy. The only point I'm making is that our system was just an additional tool for security to use; not the only one.