For a CCTV point of view, cheep Chinese ip cameras that have poe and are blocked from the internet (own vlan), having them run via frigate with a coral you should be more than enough for you.
You can the bundle this and all your other home smartness into a home assistant server.
Job done.
Probably because they were popping up at an alarming rate, and not everyone drinks that amount of beer!