Frigate is the go-to open source self hosted solution for this. https://frigate.video/
Home Automation
Discussion about general home automation ideas and projects, home automation protocols like Z-wave, Zigbee, Matter, etc, and home automation software and hubs like HomeSeer, Home Assistant, OpenHAB, Homey.
Frigate + Alarmo (a Home Assistant integration) would fit your needs almost perfectly. You can integrate various IP cameras with Frigate, including non-Chinese brands.
Alarmo will work for the sensors that aren't cameras.
For a hardware response, my go to camera company is Amcrest, in case you're looking for someone reliable and trustworthy (cameras don't require dedicated apps or internet and work perfectly with a regular PoE to an unmanaged PoE switch)
Thank you the folks who helped out. I'm looking into Frigate + Alarmo with Amcrest hardware.