Personally I'd look through the brands listed in the Home Assistant integrations, either Local Push or Local Polling :
https://www.home-assistant.io/integrations/?cat=camera&iot_c...
https://www.home-assistant.io/integrations/?cat=camera&iot_c...
The documentation for setting up the integrations should also indicate whether there's any cloud involved.