For anyone who doesn't know yet, there are a wide variety of ONVIF supporting cameras that you can setup with a local NVR running Frigate. You can block internet access to the cameras, so they can't create outbound connections, and only inbound connections to the video streams are allowed.

Tailscale has a free tier that's a good option to remotely access your network and cameras.