Ubiquiti's UniFi is an option (of many). They include doorbell cameras nowadays. There's also solutions from Logitech, Eve and others.
You can use Ubiquiti's surveillance software that's part of the UniFi console (that you can manage locally, with no cloud account), or other third party local-only monitoring software such as Synology Surveillance Station, BlueIris, and open source solutions such as iSpy, Frigate, ZoneMinder, and many others.
-- -----
Unrelated to cameras, I've preferred Eve for IoT devices simply because they adopted Thread and Matter very quickly. Nothing of them I have is IP addressable, nor can directly reach the internet. They have nice apps for phones and tablets, but I also use open source software to aggregate everything into my own dashboards (and automation) that I host and manage locally.
You can use Ubiquiti's surveillance software that's part of the UniFi console (that you can manage locally, with no cloud account), or other third party local-only monitoring software such as Synology Surveillance Station, BlueIris, and open source solutions such as iSpy, Frigate, ZoneMinder, and many others.
-- -----
Unrelated to cameras, I've preferred Eve for IoT devices simply because they adopted Thread and Matter very quickly. Nothing of them I have is IP addressable, nor can directly reach the internet. They have nice apps for phones and tablets, but I also use open source software to aggregate everything into my own dashboards (and automation) that I host and manage locally.