Now that i think of it, i dont believe my P5q-Pro has RAID 5 capabilities... And ya it's wicked expensive to get a RAID card that is not shitty that can handle the enterprise level RAID's we speak of.
My thoughts on your future build real quick...
8 Core CPU will probably be way overkill. Currently Quad cores are way under utilized and most of the time 2 cores sit completly idle. This includeds encoding/transcoding applications, ripping programs, and other processor intesive apps. Only games like Crisis utilize 4 cores... and even then the results are marginal.
24 GB of RAM, unless your running a massive VM powerhouse... way overkill. I could see 8, maybe 12 GB of RAM. But still holy shit dude. If your looking for graphics processing power look into a strong GPU. A GPU is way more powerful and utilizes RAM way more efficiently than a Processor or applications would. Windows 7 is a beautiful thing. I currently am on it, with the previous specs i listed and as of now i'm using 32% of my physical RAM so abou 1310MB currently. I'll check what COD MW2 puts me up to.
As for the HDD's. I love solid state i cant wait for them to come down. I currently have 1.36TB of internal HDD's, with another 1.2TB on the shelf waiting for a larger, more ventalated case, and a 1 TB external. I'm close to the 4 TB mark
EDIT: My MOBO allows for 0/1/5/10 RAID levels.
If i can ever afford another RE3, i'll set it up. RAID 5 makes me moist.