Historically, UniFi user interface left out some features that some of the more advanced people needed/wanted for home lab stuff. Mostly dealing with NATing and specific routing requirements. However, all of that is now in the UniFi UI is there isnt really anything it lacks for any home user no matter how advanced. The very few things left that it still lacks in relates more to enterprise level multi-site routing and high availability, and even that is progressing more and more.
IMO, UniFi is the absolute best you can do for any home, small, or medium business environment now days. Its main issue is the pricing and hardware availability. For home, it has a high price level of entry to really get a system going. For business, it is relatively cheap on pricing though, so depends on your segment. Hardware availability wise though they still have far too high demand for their supply. When something really good releases, like the Cloud gateway Fiber, you have to be lucky to find it in stock and likely can take 6-9 months before supply has matched demand.
You can certainly get all the same features that UniFi has with pfsense or OPNsense and things like that, but I really dont see the point anymore when you are likely going to be spending just as much or more as with UniFi, and then you have to go through all the hoops of installing all the software and plugins and tweaking everything yourself and fine tuning filtering rules and policies. It is far more work than just using something that already has it all there in a nice polished user interface while using less power.
Cloud Key is a hardware controller, and it can run the entire UniFi application stack. The way UniFi works is that each product subset is an application. So the Network app controls your gateway, switches, wireless access points, and wireless device bridges. Protect is the security/camera app that controls your cameras and home sensors (a product line soon to be expanded upon greatly). Connect app controls digital signage, Access app controls door access (business stuff, not home smart locks), and Talk app controls VoIP phones and all your phone lines and menu systems for VoIP. Oh and lastly they now have the Drive app which controls your UniFi NAS hardware.
So the NVR stuff falls under Protect. Anything that can run Protect can be used as the controller for the cameras, and this is basically any product with a controller that UniFi has that can mount storage. The Cloud Gateway Fiber has an m.2 slot so it can run Protect. Cloud Key Gen2+ has a sata port for a HDD or SSD (I greatly recommend SSD) so it can run Protect as well, and obviously the UNVR has storage so it can be your Protect controller. You don’t need a Cloud Key and a UNVR for the cameras, you either use the Cloud Key to manage your network and cameras, or the UNVR to manage the cameras. So since the Cloud Key Gen2+ can support up to eight 4k cameras (and more lower res ones) you dont need an NVR if you have a Cloud Key Gen2+ or Gateway Fiber unless you specifically want more storage capacity for keeping video longer or have more cameras than the other devices can manage. The limitations on how many cameras it can manage is there for performance reasons.
As another note, the Protect line does have webhook support as well which is of great interest to home lab usually. So you can use camera triggers to send commands to Home Assistant for instance. Many people use this with a G4 Doorbell Pro to use the fingerprint reader to send a webhook to HA to unlock their door’s smart lock that is also connected to HA. This way you can do keyless entry based on fingerprint and manage access by who is enrolled with prints. Some people have used the AI cameras to detect faces and on a specific face to send a webhook to HA to unlock the door, giving you automatic unlock as you or anyone you program walk up to the door. Be aware though that the facial recognition system isnt very robust and isnt intended for security access, though people use use it for this. So just like when the iPhone first came out with face unlock, people could print out a picture of your face, wear it as a mask, and walk up to the door and make it unlock. Extremely unlikely scenario for a burglar, but technically a possibility because it doesnt use full 3D analysis for facial recognition.