I use an older Sharx camera (I hope the newer ones still have the same features).
It supports all the usual cloud and remote access junk, but fortunately none of it is necessary for operation.
It does motion detection internally and only records when something happens in the frame. Most importantly, it support ftp uploading these event recordings to a configurable server.
I put it on a physically separate network which has nearly nothing else and certainly no internet connectivity in any direction (I see the camera attempting to contact google DNS every now and then). I would never trust any of these cameras, regardless of manufacturer, with internet access no matter how limited.
The only other thing on that network is a box which exposes only ftp, so the camera uploads activity to it.
Optionally, from a physically separate network you can then pull the videos to some other host which has internet access and upload them elsewhere for remote safekeeping.
But yes, it is sad that one needs to know how to set this up just to preserve basic privacy.