Reolink
Any cameras that can operate entirely offline are good. Dahua and Hikvision are good too. Look for cameras with RTSP and ONVIF support. ONVIF is a standardized API for interacting with cameras and can handle things like pan/tilt/zoom, sending events from the camera to the NVR (eg motion detection), and a bunch of other things.
I use Blue Iris as my NVR, which is usually regarded as the best, but there's other good software too (like Frigate), and hardware solutions too.
Just follow best practices - keep them isolated on a separate VLAN with no internet access. If you want remote access to your NVR, use a VPN like Tailscale.