sorry for the slow response, I didn't get "to play" for some days;)
The Supermicro board looks very nice indeed - the 2 x M.2 slots and ECC support seem ideal to have all options. This is a serious candidate for my build!
What I actually intend is to have this build run as a 24/7 file server where I just pop in one or more new disks if capacity becomes an issue. So a place where all data can be dumped and be accessible if needed. So this thing should be energy efficient and (as) silent (as possible) - for me this means that the HDDs should stay off as often as possible.
In terms of speed, I personally think it would be "funny" to build such a server if it cannot support at very least 1 x 1 GbE connection at full speed. ECC is a great option but I am currently considering to use larger cache drives which would allow to store often accessed data (e.g. user folders) in the cache which would keep the HDDs off longer. So, cache drives could serve two purposes here.
For all other things such as Radarr, Sonarr, Plex etc pp I indend to run a beefy, smaller form factor (potentially FreeNAS) server which uses SSDs in RAID for fast access and silent/quiet operation. As especially those 3 mentioned programs always seem to do something, chances are slim this server/SSDs gets to standby often. That build will be a headache in terms of energy efficiency because I want to have a fast CPU for all the fun (and serious!) stuff that I come up with to run on a server haha But having a - say - i7 and maybe even a graphic card (Plex transcoding) running 24/7 just to run home automatisation, watch downloads and the occasional movie/show seems decadent...
RE cases: I do think the Norco case is basically too big (I will have to make sure my wife is in a good mood when the delivery comes! LOL). But the big fans are great and once it runs, it should be able to run for years without any capacity worries. If anybody knows similar but slightly smaller cases (preferably rack mountable), I am happy to check It just need to be able to run quietly (with some pimping).
Cheers y'all for your input, this is helping me quite a lot!