Amcrest AD110 doorbell connected over wifi to a recycled HP mini-PC (can be had cheaply on Amazon) running Frigate (https://frigate.video/) with a Google Coral accelerator installed in one of the internal slots. The Amcrest doorbell does have a cloud video connection if you want, but I firewalled it off from the internet and use the local RTSP streaming over to Frigate. Frigate talks to my local Home Assistant install too for automation. Also built a little buzzer with an ESP8266 and a simple piezo buzzer that runs ESPHome, which Home Assistant can use to play little sounds for stuff like person at the front door, lightning strikes in the area, etc... whatever you want to. The doorbell also has a local API to expose notifications when the button is pressed, which you can link to HA with amcrest2mqtt.
The wifi connection for the doorbell isn't ideal for security purposes, but it's good enough and a lot easier than getting CAT5 to my doorbell. It is more or less 100% reliable with my home wifi setup, though again I'm not really counting on it for any sort of reliable home security.
OP is absolutely right tho that this setup requires work to put together and maintain. Configuring Frigate can be especially confusing, but there are other local options like BlueIris (paid, and Windows only which kills it for me but it is very capable). I've been in this game for many years so it's all easy to me, but getting started is definitely a learning curve. Very fun though, if it's your sort of thing. The DIY home automation community is in a bit of a golden age right now, IMO.
The wifi connection for the doorbell isn't ideal for security purposes, but it's good enough and a lot easier than getting CAT5 to my doorbell. It is more or less 100% reliable with my home wifi setup, though again I'm not really counting on it for any sort of reliable home security.
OP is absolutely right tho that this setup requires work to put together and maintain. Configuring Frigate can be especially confusing, but there are other local options like BlueIris (paid, and Windows only which kills it for me but it is very capable). I've been in this game for many years so it's all easy to me, but getting started is definitely a learning curve. Very fun though, if it's your sort of thing. The DIY home automation community is in a bit of a golden age right now, IMO.