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.
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.