Go SSD and it's even greater - once you get larger than the cache (8gb) you see diminished returns from the SSHD.
Have you considered adding something like the Samsung 970 NVME on a PCIe card?
Even on my Z800 with only PCIe2 I get 1.8GB/Sec and 1.7GB/sec seq read and write.
And transferring from any SSD to that is very fast, even USB3 can go at around 200MB/Sec and I can easily transfer 20GB file from my Ramdrive to the NVME in about 20 secs.
The only thing you must do with them is attach a heatsink otherwise thermal throttling can occur.