I use the Uniden DB1 doorbell camera. It is powered by existing wiring to your doorbell. It connects to your WiFi and has a web admin interface. Also some IR lights for night vision.

It has a shitty app but instead I just pull the HD RTSP stream over the network into my DVR. Also integrated with Home Assistant for notifications and remote viewing.

A good option for the technically-minded who want no sketchy remote access.

https://www.amazon.com/Uniden-U-Bell-Doorbell-faceplates-DB1...

They are resold under many names: https://www.amazon.com/gp/aw/d/B07888LWLM/ref=cm_cr_arp_mb_b...

There are rumors that Wyze has a doorbell camera under development

Their regular cams are only $19.99, and I've been very happy with them so far. If they do a doorbell, that's definitely the way I'll be going.

Roll your own with a raspberry pi. More work, but also way less sneaky BS.

My wife tells me uefy does local storage. Worth checking out.