One of my problems is finding reputable good quality cameras that are ideally dumb and just provide an RTSP stream. Of course, I'll throw them on their own VLAN and isolate them from the internet, but I want something with good image quality and ideally doesn't require an app or Windows to setup

Another issue is finding all of these projects and choosing the right ones that'll receive long term support and making sure the pipeline (Camera -> NVR -> Frigate -> ? -> Home Assistant?) doesn't break and stays up to date.

A lot of moving parts, and last time I looked it was hard to find a good NVR with Linux support that also has a decent web app (and even better if it has a native mobile app)