Is it worth it ?
Definitely Yes !... Actually... No...
So if we go back in our time machine, the coveted Seagate Cheetah 10K.7 Ultra320 SCSI was the fucking bomb for recording on a QS
https://www.amazon.com/Seagate-Cheetah-10K-7-Ultra320-ST3146707LC/dp/B003490AQ8Track counts were about double or more and the DAW ran like lightning, that being said, against today's SSDs you would have to really dive in and test.
There are many technical reasons why SCSI kicks the ass all over IDE, remember the SCSI interface basically has it's own CPU and controls read/write operation via the independent and high-speed SCSI card.
Also the drives themselves allow multi-access, and Tagged Command Queuing (TCQ) that allows the operating system to send multiple read and write requests to a hard drive (although newer ATA has this also). ATA TCQ is not identical in function to the more efficient Native Command Queuing (NCQ) used by SATA drives and SCSI TCQ does not suffer from the same limitations as ATA TCQ; however, AFAIK new SSD technology uses and even better implementation of NCQ.
Let's not forget the HEAT added to the system cannot be understated ! If you want to fry a few eggs up, just take out the 10K SCSI with mittens. Even the SCSI controller chips can get hot enough to burn skin.
And let's remember the whole defrag/optimize regiment with mechanical drives
My conclusion, although SCSI is so damn amazing and technically interesting, it's a dead art. It was obviously ahead of it's time, since it took 15 years to get the features into other storage technology...
Today, go for the low maintenance, cool, SSD, and leave SCSI in the history books