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.
I suppose there's always a catch with them opening up for 3rd party support.
I was keen to move to Unifi primarily for a doorbell. I had a Hikvision which was very temperamental, and I didn't want a cloud based one like Ring or Nest, so believe it or not, most of my decision was made around a stupid doorbell.