I've got 3 cameras running on a vlan, with no access to the internet.
Frigate / Home Assistant + tail scale (want to move away from this service) let me see my cameras remotely, receive notifications from events and even look at events / stills on my watch.
I have some cheap 5mp Reolink camseras, not the best for frigate but get the job done.