I guess my point is that there is no right or wrong camera system. It’s a balance between risk, convenience, and peace of mind / perceived safety.
I used design hardcore security checkpoint systems for the DHS, and even I have stupid WiFi cameras. I’m going to see diminishing returns if I go with a more old-school hardwired system. The people who do break in sprees in my area have been getting past me those things for decades.