I have a Reolink PoE doorbell camera that I use with frigate and have been very happy with it (installed around a year). I limit its traffic to the local network since it does phone home.
Frigate does local object detection. I use a Coral Tensor m.2 card for it, but there is support for GPU and CPU detectors as well.
Frigate also integrates into home assistant and supports a pretty big variety of cameras. I have a hikvision one in a different area of the house that feeds into frigate as well.