I didn't mean to sound offensive, sorry if it seemed like that.
The application you describe would be a simple IP webcam for me, not a video door bell.
In your case, I would recommend a TAP camera. I have many of them and they work fairly well. You get the usual server cloud connection, they try to sell you a subscription for cloud based recording, complimentary to SD card recording, but I never used that. You can access the cameras via IP address, however, if you buy one of the motorized cameras, you won't be able to control it in any way without the app.
What I have done to use the cameras on my PC is to install an Android emulator/virtual machine and then you get the Google Play and can install the TAPO app. That works surprisingly well. The nice thing about TAPO is that they have different types of cameras, wall plugs, lamps, etc. You can combine everything in their APP and apparently you can even create some rules (I never tried it). The TAPO hardware integrates with Google Home, too. This means you can ask Google Nest/Home/Whatever to switch on a light or stream the camera video to the TV. I doubt that TP Link and TAPO will close business in the next years, so it seems a good enough investment. I especially like the availability (big supermarkets and stores have them) and the price is great: under 10 Euro for a IP wall plug, 20-40 Euro for a camera, the outdoor weather-proof camera goes for around 45-50 Euro. They have a more expensive one, too.
If you want to really have something better, the way could be via Raspberry Pi with the Raspberry Camera module. Print your enclosure and access it via VLC?