On my last tests I was able to achieve over 600 MB/s read and 800 MB/s write with SMB on a multiple Raid-10 Pool (12 disks) quite constantly with an AjA video test (4k, RGB) on Windows 10 (MTU 9000, int-throttelling off). With an older OSX (If I remember correctly 10.11) the values with Disk Speed Test with MTU 9000 were quite the same. For a single user results with SSDs (Sandisk Pro 960) were only slightly better. With three concurrent running benchmarks the degration was lower with SSDs but quite stable over 500 MB/s. This was done on OmniOS (free Solaris fork). The results with the commercial Solaris and native ZFS were noticable better than OpenZFS from OmniOS. For sure SSD only pools are faster especially with concurrent use. In the above scenario with hot, medium and archive use, I would propably start with the disks for the medium use (disk based) and check if performance is sufficient. If not, I would add a second SSD or NVMe based pool for hot data and use replication to backup to the other pool. For archive, add a Jbod case (up to 90 disk bays) with an extra pool that start with a few disks ex a single Raid-Z2 and can grow with more Z2 up to the Petabayte range and connect with external SAS 12G. With current OSX (MacPro, 10G Promise Sanlink) I was not able to reach these values again. Even with SMB signing=off (a usual tuning suggestion) I never got more than around 300-400 MB/s for a single user. I have not compared iSCSI on current OSX but would expect this to be faster. With a few editing stations, a dedicated 10G ethernet link would be also an option with one or two additional dual 10G adapters.