I went down the rabbit hole a while back, I have the space so I went with an old Dell R720 server rack with 24 cores/48 threads, and like 128 gigs of ram for 300 dollars off eBay.
I flashed the raid controller to IT mode using this guide
The perk of going this route is that I can run UnRaid which has an awesome web interface for creating docker containers and content servers.
At the same time you get the ability to add drives over time without having to rebuild your array. I started with a cache, parity, and storage. Over time I have added an additional parity drive and 6 more storage drives.
With this setup and similar you also can use SAS drives. Used helium filled enterprise drives are around 80 dollars for 10tb.
I run a plex server with mostly 4k content, game servers, Wordpress, pihole, media grabbers (aars), seedbox, home nas and countless other containers basically 24/7.
It works incredibly well especially for the price, but it is large. If you have space I highly recommend it. I run mine in an insulated crawlspace lol.
Average draw would be similar to the other person 200-300 watts under load. And 140 watts idle. My server is really only super loud on boot. The noise levels are a none issue for me.
Most the drives I get I scan the smart data and most have nearly no usage on them. The drives are cheap enough and running parity I am not too worried about data loss. I have been running the server for 2.5 years now and I have yet to lose a drive.
I run these guys and with a ssd cache I really have zero complaints. Like I said my main priority was 4k video and they handle even the largest file steaming without issue. Although I try my best to avoid transcoding and using a shield to minimize that.