I myself use the SATA II. I have 3 bays in use, 2x western digital 500GB (one of them being the OS), and a newly added Seagate 1.5TB. On top of that I have 5 LaCie external drives, 4 of them hooked up by SATA 1, originally hooked by FireWire 800.
It all depends what you do with your Mac Pro? Your job, your hobbies, etc.
RAID is expensive, and honestly it hasn't perfected itself yet; SATA II has and buying disk space for it is so cheap now.
Let me give you an example, I use my Mac Pro for editing HD footage, I'm a indie filmmaker. I deal with uncompressed HD 1080p footage (using £5000+ cameras). I require fast hard drives to pass the gigabyte-heavy footage to and fro between tasks, applications, rendering and compression. Generally I used to use FireWire 800 which was enough but it would lag often but didn't take forever (because I moved about so much I used LaCie external drives as my editing platform and backup on other ext. drives). I have just recently added SATA PCI-Express card to my machine and now using 1.5gig/s SATA on my ext. LaCie drives and already I notice a massive improvement; I don't hear the drives making whirring noises anymore trying to look for the footage as I click it in Final Cut Pro 6 browser.
So picture me being impressed as an editor using 1.5gig/s SATA drives, then add to the fact that you and I can also make use of SATA 2 from the internal drives: 3gig/s. With me so far?
Yes, the new Mac Pro you can select to add RAID but it is very expensive and cannot have as much GB space as you do with SATA drives. And to then add it to a already SATA made Mac Pro is very expensive and arduous. SATA is the new IDE. It's good and affordable, whilst RAID is still evolving but soon it'll be the norm. Yes RAID may be safer with its data, but honestly, most drives now are so strong and reliable, and cheap to buy for backups, RAID is just too expensive in my opinion.
Again, what do you use your Mac Pro for, that's the question, what do you need it to do?
(Apologies for being a long post).