Not exactly what you asked for, but I went with Eufy with local storage. There is a home base so everything is stored here and not in the cloud. Costs a bit more but gives me peace of mind.
Downside is that it won’t work if my internet or power is out, but that happens once a year, max.
For door I’d go with Yale with the hub to lock and unlock remotely.
Don’t know of a combined solution, sadly.
Poor wording on my part.
It still functions, but I don’t get push notification when it detects motion or someone rings the bell while I’m out. I will see the recording once I’m on my local network again.