Depends on the game and whether or not there's a lot of sequential reads going on, as that's where raid-0 makes the biggest difference.
SSDs though will definitely make a difference. In Arma2, games load up in a fraction of the time it took on my mechanical HDs.