I can’t provide precise answer, since some services rely on HDD performance, while others enjoy big amount of RAM.
Personally, RAM and reliability are two things I’m after when entertaining the idea of a home server.
For example: I’m about to build a very simple file server + jellyfin + printserver + RDP rig and it’s going to be based on DELL 5040 + 8Gb RAM + 4Tb SATA, running… Windows 10 Pro. 🤠