I’ve only been looking at the Raspberry Cams for the moment, as my thinking was that I wanted to keep all the components as compatible as possible to make my life easier.
Though for security cameras, maybe @eagleeyedtiger would have better knowledge around what is good out there?