Just to add on to this:

Frigate is a open source solution that'll take any RTSP capable camera and give it super powers. All those AI features the companies like Ring and Nest advertise, but locally. Sure, there is a learning curve - but it isn't atrocious. And you'd need local hardware, but if you have a PC you could throw a $110 Coral USB Accelerator and get all this.