I started with an N36L back in the day, I now run an SC847 as my primary with 36 bays, theres a certain irony to that I suppose.
If you'd like general advice, don't buy commercial grade hardware till you have to, a 23 drive Fractal Design Meshify XL chassis in storage mode will generally use a lot less power than the same hardware in a server chassis with a server PSU/backplanes/fans, it’s also more portable and will be easier to live with (heat/noise). Cache is better on an NVMe than AHCI/SATA, a mirror is better for redundancy, high endurance NAND can be cheap, I have drives with endurance my children will need to worry about. BTRFS is not your friend - it will bite you sooner rather than later. Intel is still the best option, anything around 8th gen onwards has the HD630 and that will do more transcodes than any non commercial provider needs. Never underestimate connectivity, hard wired clients that support H265/HEVC are worth upgrading to, especially if they can be hard wired. SpaceInvaderOne’s work is great, but sadly often outdated and in some cases incorrect, TrashGuide for example is the correct way to set up your shares for efficient moves. HBA’s are a great way of breaking out storage, but run hot, use a fan or a chassis with high CFM. Storage wise SATA supports spin down, a plugin should support SAS spin down, but no guarantees. Helium drives have obscene MTBF’s - read and learn how to convert drives to fully utilise capacity and enable cache as in the enterprise world, its often enabled by the controller rather than as default by the drive.You will always need more storage than you think, density is important, as is efficiency, but don't obsess over it. Buy a suitable UPS and test it - unplanned parity checks are bad, unplanned UPS failure can be even worse. I always move my USB drive to an internal header, adapters are cheap and it saves it being knocked or removed, don't buy Sandisk USB drives.
Unraid’s strength is in storage using mismatched drives and ease of expansion not its performance, its not comparable to VMWare or Proxmox in VM terms or TrueNAS in terms of resilience/IOPS, its got a very simple implementation of ZFS at best, if you want commercial best practice, consider something else, UR is about ease of use and firmly geared to the home user.