As I don't require that much media storage I'm most likely going down the Raspberry Pi5 route.
Along with the Pi5's 4No USB-A (2No v2.0 and 2No v3.0) ports it's possible to fit a 4-port SATA drive hat to increase the number of HDD's you can connect to it...
All as detailed here:
Over the past 6 years I’ve built 5 NAS systems with these SATA hats, although always with the RockPi version (5 drives, one of which is eSATA) and not the Raspberry Pi.
ZFS on all of them. All have been very reliable. The last two were built with a real hot swap raid chassis that holds full sized (3.5”) drives, which lets you go up to very large (20 TB +) drives that aren’t shingled (so faster writes).
“Full sized” used to be 5.25” LOL. I deployed a ton of Seagate “Elite 9” drives back in the day - 9 GB!