An SSD RAID will > HD RAID w/same no. of disks, but as one poster mentioned/implied, you get into diminishing returns re: real-world performance improvement vs cost. More RAM and a fast scratch for Photoshop use will save you more time for the same or less $$$
Since once open, the Mac OS (making assumption here) will keep a program in memory for faster-reopening, an SSD RAID is not only 2x the points of failure but maybe bordering on overkill unless you're opening/closing different programs a LOT.
I'd be tempted to move to 1 SSD for boot/programs and another (assuming a 3G connection to exploit it) as a scratch disk & maybe a boot clone (via 2 segment partition) of first SSD in case of issues?
My pair of 16Gb RAM 2.2GHz MBP 8.2s (late '11) use solo 3G SSD for boots & apps and opening apps. is almost instant.