Gregory's Server
I had this same search and went with an amcrest POE camera backed by Frigate. No cloud. No privacy issues. No subscriptions.
I think (could be wrong) Amcrest’s doorbell camera is WiFi but I went back to a boring old doorbell and am using a turret camera.
Works beautifully.