Not sure why you are downvoted. Reolinks work without internet and can stream locally using rtsp. I have a doorbell cam from them and it works fine. If you block it from the internet you only get video and basic doorbell functionality though, which is fine.
The difference if you can film out on the street (random people walking by) or just your property (my own fault if I approach your door).
Some countries have laws for this, as in you can only point the camera so that you don't catch everyone. This can have downsides, e.g. if you have no (even short) front yard and your (organization's) door is directly on the curb - but I completely agree that this is just tough luck, the privacy of random people walking on public property past private property should not be filmed.
You can also stream Reolink video to a Frigate box (free software) and access that from wherever.
No cloud involved if you run your own VPN.
Or even better, _just a little_ cloud involved if you expose through Cloudflare tunnel for just you and whoever else needs to access it.