Sometimes. More often, it comes down to the controller chip used on the card (not only it's SATA specification, but how it handles PCIe traffic).
Which is why the more expensive cards tend to run faster, even if the SATA specifications are the same vs. a budget card (better PCIe traffic management, which requires more than 1x PCIe lane).
Here's a possible configuration that should improve matters noticeably without breaking the bank...
Primary storage:
- SSD for boot/applications
- SSD for Photoshop scratch (separate unit, not shared with OS/applications; does not need to be very large either, so something like a 40GB would do)
- HDD for data
All of this using the MP's SATA ports, no cards or USB ports at all (makes it more cost effective).
If you're after faster ports, then it's going to get expensive (need 2x PCIe lanes per SSD or better + boot capable = ATTO or Areca RAID cards). Areca's cheaper but probably a lot more than you're expecting (i.e. ~$360 for an ARC-1213 4i, and more for an ATTO, and it can go up from there <over $1k just for a card

>). Speed is not cheap, and the faster you try to go, the uglier the price tags get.
Backup system:
- PCIe SATA card that works with Port Multiplier based enclosures
- Port Multiplier (PM) based enclosure (note that one SATA port is good for up to 5x disks max, so if you need 8x disks, then you'd need a 2x SATA port PCIe card).
- HDD's (Green models will do for backup)
- Configure as single disks, or perhaps JBOD via Disk Utility (10 would cut your storage capacity in half, while JBOD allows you access to all of it in a single volume).
Example kits that you'd only need to add drives (
4 disk version,
8 disk version).
This is on the slow side, but it's backup, not primary storage = acceptable solution.