A simple way to ensure your selfhosting is easy to manage is to get a NAS for storage and then other device(s) for compute. For your current plans I think you’d get far with a Synology DS224+ (or DS423+ if you want more disk slots).
Then when the NAS starts to be not enough you can add an extra device for compute (a mini pc or whatever you want) and let that device use the NAS as a storage.
Oh and budget to buy at least one large USB Drive to use as a backup, even if your NAS runs a redundant RAID.
A DIY solution like your home server is great. I’m just adverse to recommending it to someone who need to ask such an open ended question here. A premade NAS is a lot more plug n play.
Personally I went with an ITX build where I run everything in a Debian KVM/qemu host, including my fedora workstation as a vm with vfio passthrough of a usb controller and the dgpu. It was a lot of fun setting it up, but nothing I’d recommend for someone needing advice for their first homelab.
I agree with your assessment of old servers, way too power hungry for what you get.