I have a local one (reolink). Prompted by neighbors getting robbed unfortunately. Will this prevent crime? Maybe some but probably not all. But it would let me know if I have to file a stolen package claim or should wait on the package for a few more days. Plus it has been doubling as a trail camera for the local fauna I had no idea came by so frequently. It faces private property only as it is set up.
You can always put the cameras inside the home and disable WAN access. Best of all worlds.
Not sure why you are downvoted. Reolinks work without internet and can stream locally using rtsp. I have a doorbell cam from them and it works fine. If you block it from the internet you only get video and basic doorbell functionality though, which is fine.
The local law enforcement will likely not have the time to chase individual small cases either...