Well, depends what you want. I presume you're going to use the RAID available on your mobo, which means you are limited to RAID 0/1/10
RAID 0:
Well, probably the best for gaming, although AT did a review of 2 Raptors in RAID 0 which didn't perform significantly faster than a single Raptor. But basically, RAID 0 is when you have to drives configured and when you write data, the RAID controller writes to both drives meaning each drive only writes half of the data hence theoretically doubling performance. But of course, it doesn't double performance in real world. Most benchmarks tend to show around a 20-25% increase depending on what you do but random read/writes tend to improve more than sequential read/writes. However, if any of the drives fail, you lose the entire array, hence destroying all data and recovery is expensive. This means that you are effectively halving your MTBF but for current drives with 3-5 yrs of warranty, it usually doesn't matter since they last so long anyway.
RAID 1:
Best for permanent backup. When you write data, the same data gets written to both drives thus creating a perfect backup. Write performance is theoretically the same but read performance goes up as both drives are used to read different pieces of data. However, if you link say 2 160 GB HDDs, you only get 160 GB from the array since the other drive is being used as a permanent back hence you pay for RAID 1 in terms of HDD space.
RAID 10:
This is basically a combination of the two above. This requires a minimum of 4 HDDs to work. Two of the drives will be in RAID 1 and those two will be in RAID 0 with the other two drives. Hence, you would theoretically get the performance of RAID 0 as well as the redundancy of RAID 1. Read performance however goes through the roof as all for drives are used for reading. But as for RAID 1, you lose half of your disk space so that's the con.
Another note, if I am correct, mobo RAID controllers tend to use the CPU to perform the RAID, which although for these RAID levels present very little load on the CPU, it still does use the CPU hence might not help with gaming all that much (IMHO). If you are really considering RAID, quite a few people on this board have sworn by RAID 5 which will require a dedicated RAID controller which is not on the mobo. Try googling RAID, you would get an even better explanation than the one I have provided here.