I'm a big fan of the Intel NUC platform, coupled with a fanless case and all-SSD/NVMe drives. They're low-powered, fast enough for most common tasks, and completely silent.
I have an NVMe drive for the OS (currently Proxmox, soon to be Debian again or Fedora), containers and VMs, and an internal 8TB SSD for data storage (whole disk encrypted). This may not meet your needs if you're intending to be a data hoarder, but I have a sizeable movie and lossless music collection accumulated over 25 years and I'm not even using 4TB yet.
You can of course still use a similar setup but keep even larger storage on a NAS device, or simply use a USB dock with a couple of 16TB drives. It's really down to whatever your needs are.
I love that the server, router, modem, and switch use such a small footprint and are able to be powered for up to an hour by an equally small and inexpensive 600VA UPS.