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