I don't know about Fedora but it works well with Gentoo. You should know that the sil3112 controller is not a "true" RAID controller - it actually does software RAID on-chip. The Medley RAID setup can be accessed using Thomas Horsten's Medley driver
or by using the RAID-detect tool
. David Dollar has some good info
This above is all for using the controller using it as quasi-hardware RAID. Using the drives as regular drives or using LVM (Linux software RAID) works fine. The kernel has two different drivers for the sil3112 controller - the regular EIDE/ATA driver and the libata driver. Both work well with current kernels (2.6.5, 2.6.6) and your box will most likely run fine "out of the box" with a new distribution.
However, the nforce2 chipset has some issues you may want to know of: Booting the kernel with "acpi=off" and "nolapic" does wonder for the stability of the chipset.