Again... this is so with modern SATA 6Gbps MBs. Mine is a dinosaur with SATA 3Gbps. MIGHT make a noticeable difference.
But again... assache factor with having to switch boot modes in BIOS all the time.
mnem
Hmmm.... I could put a enable switch on the SSD's power lines...
SATA 2 or SATA 3 shouldn't make a huge difference either. The key to SSD performance is its random read performance. That's what makes all the difference in the world when running an OS or a database. Raw sustained throughput is nice, but rarely the limiting factor. If it is, it's typically for very short periods of time. There are workloads in which it does make a difference like the aforementioned video editing and rendering, but even then it's not necessarily going to set the world on fire. It becomes relevant when you do it often regularly.
But yes, the issue with RAID is that it is much more finicky than just buying a larger or faster disk. Rebuilding or more frequent failures, unsupported scenarios and all that good stuff. It's fun to tinker with, but can be a PITA when it craps out on you at the wrong time.