I have an SSD with Mountain Lion and Win 7 installed on it, and a 500gb HDD for my media (music and movies mostly) and torrents. I would strongly recommend one SSD with the operating systems on it, and put the money saved from not buying two SSD's into an awesomely fast and huge hard drive to store all your files.
But yes, it would be better to put Windows on one drive and OSX on the other, that way when Windows ****s up you don't need to worry about your Mac as much. And anyways, i don't think you can put Bootcamp on a RAID array.