I've even done some serious work in Logic on a MBP with only a single 7200rpm 1TB drive. not a hiccup.
No doubt, but Virtual Instruments hammer DAWs!
Every typical note requires two voices (stereo). Grab a fistful of notes and you are working your machine like an audio project with that many stereo tracks. Try adding some drums with BFD where each strike can trigger 10 or more samples simultaneously. Or a virtual synth with several layers. Now, start some serious overdubbing. Uses the sustain pedal on your piano with full-length decay samples. Detailed orchestrating. Doubling and Tripling. It is easy to see how the folks doing virtual orchestra work need some pretty serious i/o.
OP, please don't neglect the "back up" once you get your multiple gigs of libraries loaded on your SSDs, especially if you RAID0... re-loading libraries is no fun, and if one SSD fails in RAID0, your whole library is hosed.
One nice thing about SSDs is, because they are so fast, you can use smaller sample RAM buffers, which speeds load time when you start up for the day even more. Look in your sample engine preferences. Not sure, but almost certain that just about every sample-based VI is streaming from disc; only the attack portion of each sample is loaded into RAM.
I'm currently running four SSDs in my hex MP, one for system and apps, one for project and audio files, and two feeding samples to my VIs, with samples allocated in a (hopefully) intelligent manner to maximize throughput. I have yet to "wear out" an SSD, and my system is ridiculously responsive. Don't be afraid to use your SSDs!
And, especially if you are doing sound for picture, don't neglect to check out Digital Performer. I'm a long-time user, not a paid endorser. But I like it a lot.