SSD's have a huge disadvantage, that is that sectors can only be written a limited times, then they go dead (corrupt). I've known hosts whom have used SSD's for database hosting, which initially sounds smart, as they have super fast read speeds, but if you think about it databases need to be written to continuously (think about session management) so the SSD's lifespan will be shortened significantly.
SSD's are great for fast read speeds, and as little write-ing as possible, so for the system/boot partition (not /home or databases etc.) yes, although, those systems don't need to be rebooted/read constantly so I doubt if it will significantly improve anything.
I'd definately go with SATA drives in a RAID1 (or RAID10 if your crazy).