SCSI didn't go away. Actually, in the last few years, the enterprise drive of choice has been SAS (Serial Attached SCSI).
A RAID array of 7,200 RPM (SATA) drives can be significantly faster than a single 15,000 RPM (SAS) drive.
Having a RAID array of 2 (or more) 15,000 RPM drives is a better option yet.
Then comes the question on what type of RAID. "0" is fastest, but if any one drive dies, all of the data is lost. Fortunately, the drive failure rate for the 15,000 RPM enterprise drives is VERY LOW.
Also, you have to have a controller for the 15,000 RPM (SAS) drives. I don't know of any "desktop" motherboards that have onboard SAS or SCSI controllers. You would need an additional controller card.
Many good desktop boards do offer onboard RAID controllers for SATA. That means you could but a couple inexpensive SATA drives and configure them into a RAID array for relatively little $$$.
If you decide to go the 15,000 RPM route (SAS), the extra cost of the SAS controller and the higher cost of the 15,000 RPM drives is significant.
It all comes down to, "How bad do you need the speed?". If money is no object, the SAS RAID route is faster. We sell many SAS systems due to the fact that high-output print and wrap shops NEED the fastest system that they can get their hands on. Several thousands of dollars is a drop in the bucket compared to the amount of $$$ they make by speeding up the design process.
We also sell many SATA systems due to the smaller shops not quite needing the extra speed all of the time. Money is a bit tighter and SATA RAID can be pretty fast.