I'm also in the market. I've heard good things about Reolink cameras in this regard. I'm planning on linking them up to a Frigate hosted NVR. My plan is to pounce on any black friday deals that come up this month, but curious if people have other recs.

I've been playing around with https://thingino.com They have a list of compatible cameras that are relatively affordable.

Set up 4 reolink RLC-510A cameras at my place when we moved in. Was running them off of ispyagentdvr for a while but a friend of mine has been working on an NVR that I'm currently testing out that works well.

Completely local POE cameras that didn't break the bank and a free NVR that's easy to set up and manage.

Highly recommend Reolink for this purpose

I’m rocking annke cheap-ish PoE cam on a dedicated vlan for years now. Coupled with Frigate. I still keep an eye on sus traffic attempts but so far so good. Before that I was using Synology surveillance station but nowadays Frigate is better imho. Funky to hook to HA for alerting and all.