I had inherited a dual xeon 64gb ram server and I started tinkering with home server stuff. But its loud and hot and very much meant for a datacenter and not a basement.
So I'm working on migrating the server to raspberry pi's and AWS, depending on power needed and ARM availability.
My only issue is that a dual xeon with that much ram can run a LOT of stuff at once. and I have a lot of minor things packed into it. I think almost all the stuff will run on raspberry pi's, but I might wind up needing 20 of them at this point.
But yes. I think a small NAS and a raspberry pi running a media server should basically be a given for people these days. It's an amazing concept to actually own and control data.