Frigate NVR + Amcrest cameras. 100% local, private, on-device AI object recognition and classification. Can use a Google Coral USB TPU to speed that up. Runs on hardware as modest as a Raspberry Pi.
Frigate no longer recommends the Coral accelerator. I think Hailo is recommended now
Otherwise Frigate is great and integrates well with Home Assistant. I have a light on my office desk that comes on when a person is detected near the house, for instance
Object detection, and then human detection, is extremely useful. Thankfully thats become nearly trivia enough to happen on device, but even with just "dumb" cameras the open source, on network solutions are very good.
The other half, at least for Ring doorbells, is making it easy to get push notifications when button pressed, with instant two-way connection for chatting through the camera.
It's already hard enough as a "certified homelabber" to get these things set up and running.
(Yes, I know you did the post with "haha, this is too hard for average human", but it really isn't. Don't be a big corp shill.)