UniFi Doorbell? It doesn’t require a cloud connection and remains local, can be integrated into HomeAssistant / Scrypted / Homebridge.
The above mentioned Reolink doorbell will happily run with any NVR from any other vendor that supports relevant standards (ONVIF). Or even without NVR (it has microsd slot for local storage on device).
They have released a standalone POE product, separate from the WiFi offering which has the USB-C to POE cable.
The console can be self-hosted on any device.