Reolink + frigate

Reolink for better cams.

Whatever you do, don’t buy Amcrest. Long story ending in people talking to me through the camera’s speaker.

Don't use any cloud connected IP cameras. Run regular CCTV cables to the cameras and terminate it to to an digital NVR that saves as video files. Keep the NVR on a security VLAN with strict network policy (no dialing out) between the security VLAN and your home network. Use a general purpose linux box on your home network to run a file pull to grab files from the NVR and dump them onto a local NAS. Once the files are on your NAS you can do what you want with the recordings, like any kind of data lifecycle you need on the files.

I went down the route of twinio on their supported cameras. Mostly wyze cams. Then used frigate on Unraid.

I use Zoneminder, it's not flashy but it just works.

There seems to be a ton of open-source NVR software. Here's one list with a bunch of them.

I went on a search a few years ago and found it to be like a rabbit hole of different choices. The one I ended up trying because it seemed relatively simple and lightweight but yet pretty obscure was called SentryShot.

Edit: you may also want to ask on !selfhost@lemmy.ml