Yup, my setup is local RTSP cameras with firewall rules to completely block traffic to/from them, local Frigate server that pulls the stream and runs object recognition and handles recording, and then a Wireguard VPN if I need access from outside the local network.

It's been very reliable, has no fees, and I'm not worried about cameras being hacked or cloud storage issues.