APC is nice in an enterprise-like setup and the management software is really mature. That said, you don’t get much for your money and for a homelab, I’ve been happy with my Tripplite UPS which was about half the cost. I got the expansion battery as well and the whole setup cost me less than $700

Is it still aimed primarily at HDDs or does it have SSD utilities now? As I understand it, most of its wiping methods are/we’re geared toward HDDs

For Frigate especially, you are going to want to use multiple Coral TPUs to handle inferencing. I really can’t speak to the CPU requirements but I know a lot of people like using the Intel NUCs with mic tier processors.