SCSI vs IDE raid. SCSI rules in windows. IDE rules when there are long transfers. with IDE raid, you'll see a small improvement (a second or two) in windows start up time, and your games and their levels will load faster.
with SCSI, becuase they have insanely LOW access time, it is great for speeding up your whole computer, and you don't have to worry bout IDE channels, or anything like that, when you want to upgrade. a high end SCSI drive is pretty quick too. I think they top at around 40 megs/second, which is where IBM 75GXP drives beat them (becuase the outer edge of the disk has alot more data going by then the inner edge).
SCSI means this. upgradeability. Low CPU usage. and quick overall computing experiance. you can also save IRQ's by disabling the onboard IDE controllers on your motherbaord.
IDE RAID means this. no upgradeability, same CPU usage as normal IDE, some increase in computer speed (not in all areas necessarily), and more IRQ's taken up. it's also cheaper.
with SCSI, you could get a RAID card, and one very nice SCSI drive, then when you want to spend the cash, you could add the second SCSI drive (probably at a lower price then the first), and set up RAID. and if you want, you could also have more then 4 drives in RAID (depends on the card).
however once you talk about more then 4 drives (on any typical transfer if you were doing striping, you would fill the SCSI card's limits in terms of bandwidth), you need to address the PCI bus limit (133megs a second).
obviously I recommend SCSI! IDE RAID isn't worth it IMHO. then of course is ATA-Serial, which looks ok, probably great for RAID (multiple drives), however SCSI drives will always have their superior disk access time, and lower CPU usage (don't buy into the ATA-Serial being lower CPU usage).
it's probably going to be good in terms of price wise too.. so if you want a major RAID rig without too much $, then ATA Serial would be good, however disc access time is very important too, and IDE drives still haven't gone to the extremes that SCSI drives have to reduce disk access times).