I'll second this, also adding that while it remains more of a project to setup Frigate has made significant advances over the last few years and has improved a lot. So if you previously looked at it and were put off, might be worth looking at again.

Also fwiw, if someone is willing to spin up a Windows VM or are running that stack anyway than Blue Iris is probably the default contender for local security software, well polished. I know a few people who still keep a single remaining W10 with GPU passthrough install just for that, not even for games anymore where Linux has gotten good enough in the last few years.

All of this though benefits a lot from already having some sort of homelab and/or self-hosted stack. If you do then the marginal investment may be pretty minimal and value quite high as you use it for a lot of other stuff. If starting from scratch it's a lot more of a haul which of course is precisely why a lot of people use other solutions.