The OS is completely oblivious to RAID0. The raid controller/software handles all transactions and the CPU (either the RAID dedicated or your normal CPU) handles all computation and access of the raid stripe.
A normal dual HDD configuration is like having two bowls and one hand. You have two bowls of chips but only one hand to eat them. Adding RAID0 in there allows you to use both hands and both bowls. Your data, theoretically, is accessed twice as fast. You go through your cheetos in half the time.
However, theory is just that. RAID0 requires a lot of processing power, if you are using mobo-onboard RAID, your intel/AMD cpu handles all processing. In this case you are costing yourself probably 2-8% cpu power. Onboard RAID processors still require 2-4%.
Now, assuming that you are eating with both hands, you still can only chew so much and your mouth is only so big. Your chewing capacity and mouth size are like I/O requests on an HDD. For your normal consumer, you aren't requesting that many I/O when you are playing Quake4/Doom3/HL2/WoW. Thus, your hands, while able to feed your mouth 2x as fast, are serving no purpose other than making a big mess while your cheetos get stuck up your nose.
So, while you may experience some additional speed, such as a 3 second better map load (everybody else may load in 12 seconds you get 9), your actual FPS do *NOT* increase. Your window loads may be .5sec faster and Outlook may be .01 sec faster, but thats about it.
The net gain is you are costing yourself 5% cpu power and getting 2% more speed.
Furthermore, if one HDD fails you lose everything. If an HDD has a 1% chance of failing, then you have 2+% chance of losing all data when using RAID0.
RAID0 is meant for high-end servers with lots of medium/large queries of data chunks and a lot of I/O requests hammering it at once. It is *NOT* meant for a small number of small/med queries sporadically. Even then, most enterprise applications use RAID5, a much superior (but tad slower) RAID application.
So, to summarize.
1. 2% increased speed
2. 5% less processing power
3. Double (or more) chance of *TOTAL* data loss.
That good enough?