You won't be able to run both an OS X and Windows array on the logic board's SATA controller. You'd need one of them on a separate controller, as Disk Utility modifies the firmware settings, so Windows or Linux will no longer boot from the ICH.
Also, if you wish to have 2x independent SSD arrays of 4x disks each, you'd want a separate controller for each. The slot configuration could pose a problem here (see below), as you must have a separate RAID card to boot OS X and BIOS (one card CANNOT boot in both EFI and BIOS environments, as the ROM can only store one or the other).
As mentioned, the Pro Drive won't work with the 2009 systems, but that's not an issue for you. However, you'll suffer performance issues.
The logic board's SATA controller (ICH in the chipset), is only good for ~660MB/s. As SSD's are available that can push the limit of 3.0Gb/s SATA ports, you can't install but 3x before you're going to be throttled (set runs slower than is technically possible).
A separate PCIe card is the only solution to that, and may have limits as well (depending on the number of drives used, their actual throughputs, the card model, and the slot used = specifics of the setup). Remember, Slots 1 and 2 are 16x lane Gen 2.0 (500MB/s per lane), and Slots 3 and 4 are 4x electrical Gen 1.0 (250MB/s per lane).
Those devices use Port Multiplier chips, and are capable of either RAID 0 or 1. That means you're switching the port between the disks, and the overhead involved slows down the throughput to less than the port is capable of on a single disk. ~200MB/s under a stripe configuration per unit (sold by others as well).
But Spacedust's system is a 2008, so they would be able to be used from a technical standpoint (fits the trays properly = ports will connect to the cable end back in the bay, which is attached via 2 metal tabs that hang down).