A security camera based on motion sensors that does not have access to the internet would be a good product or DIY project.
When it comes to property crime, law enforcement agencies cleared 18.4% of larcenies/thefts, 14.1% of burglaries and 13.8% of motor vehicle thefts.
14.1% is very low. But this figure is not broken down by the type of evidence available to the police. Can a large part of the 14.1% be cases where recordings from security cameras were available?[1] https://www.pewresearch.org/fact-tank/2020/11/20/facts-about...
That might work, but might also be circumvented at some point. I.e Amazon security cameras can use the neighbors cameras network to phone home.
Restrict them from internet access and you don't have to worry about firmware updates too.