Not FOSS, and with an entry price tag, but I ditched my OPNSense firewall for a Ubiquiti UDM Pro SE router about 2 years ago and invested in 3 of their cameras plus a doorbell and love it. I previously had Blue Iris for CCTV.
The Unifi Protect app is great. Easy to navigate, great detection, and easy to store clips. There's no subscription fees, and I get a great firewall/router alongside a CCTV package.
Oh, and you can now add 3rd party cameras to the Unifi Protect system.