go the synology or ubiquiti route if you want to self host in a user friendly way for other members in your house who don't want to fiddle

-unifi or synology networked video recorder in house
-no external access to the video
-glinet mini router hooked up to your network that hosts wireguard vpn or tailscale
-to view security footage remotely you vpn into your house and then open the synology or ubiquiti recorder app

all data is self hosted and firewalled by your home router