I don't have input on cameras specifically, but I have gone pretty deep into trying to understand how to maximise security and interoperability in smart home stuff, through open source control.

A starting point for the you-in-control app to use for smart devices is Home assistant. I was surprised by how easy it was to set up self hosted smart home stuff, largely because there's loads of guides that build around home assistant. So whether a particular camera works with home assistant is a good starting search filter

Only cameras I recommend are not consumer priced :/ Axis. You do get full access, can run your own code and offline etc.

Reolink for the cameras and deny them internet access. You can tell them to record to internal SD Card and / or setup an NVR like Frigate. If you don't want "roll your own" headaches and have the money for it then use gear from Ubiquiti and UniFi Protect.