While it is still kinda connected to the cloud, I finally installed a security camera thanks to Apple HomeKit Secure Video. All of the processing is done on my HomePod or Apple TV and stored in my iCloud encrypted. If marketing is to be believed, Apple themselves cannot un-encrypt it.

Its not perfect, but I feel mostly safe having this camera now.