+1 for Unifi Protect. Their hardware may be a bit pricey, but it doesn’t require any cloud/Internet connection and the app/interface is excellent.

I haven’t tried the 3rd party cam support, but I don’t think the price for the cameras is too outlandish for what they are and how well they’re built.

Iirc the Unifi Protect software can be self-hosted now too.