I don’t know much about rPi specific models. For outdoor security cams I always go wired with PoE IP cams that at least have an RTSP stream, that way most standalone NVR software can work with them.
Not a fan of wireless/battery security cameras. I do have one wireless indoor cam, but it’s only to check on the toddler when she’s sleeping, it doesn’t record so no constant stream of data. I think I’m using a cheapie Amcrest out front, I haven’t really looked at cameras in awhile. Dahua’s are often recommended on places like ipcamtalk.com, but you need to look at specific models as there are a lot of them.