Start by asking yourself, "What type of performance do I need?"
If you can get by with 100 solid tracks of 24Bit/44.1k, a single fast conventional HD will suffice.
If you need ultra high disk-streaming polyphony (500 to 1500 simultaneous notes of polyphony) from a sample library (LASS, Hollywood Strings, etc), then you'll want to look at a dedicated SATA-III SSD.
Fast SATA-III SSD drives sustain over 500MB/Sec.
If you connect two in RAID-0, you can saturate the SATA-III bus (not gaining a whole lot).
If you need super high polyphony, your best option is to use multiple fast SATA-III SSD drives (each sustaining 500+ MB/Sec).