It's a simple machine - Ryzen 3 2200G, 48GB of DDR4-3200 running at 2933MHz, B550 mATX motherboard (most power-efficient AM4 chipset + has built-in 2.5GbE and PCIe 3.0 for all chipset lanes), with a mix of NVMe and SATA SSDs along with a few 4TB HDDs that are currently always off.
I went with the 2200G because I already had it, but you could easily get much better performance using a 5600G or 5300G, or a 4600G if you can find one.
Handles all my tasks no problem (PhotoPrism, Jellyfin, and general file server duties for the most part). I've got a big fat tower cooler on the CPU and I can't hear it even under full load.
It used to be a 3900X machine when I had much higher compute requirements but I swapped out the CPU when idle power became a bigger concern.
15-20W at idle for my all-SSD Ryzen server, 10W or so for networking (2.5GbE router), and around 10W for my personal machine at idle, so around 35-40W total for my stuff.