For NVR - it looks like you are after Frigate with object detection.
For cameras - as long as it has RTSP support, then you should be fine. Doesn't really matter of what kind of brand it is. You can always block internet access for a camera in your router.