I have tested the following using sata.i kernel from the 10.2 cd, paired with two 320GB wd hard drives

Promise SATA-II150 TX2plus - mounts fine, installs fine, but when using it in the real world it causes data corruption. dmesg shows hundreds of read/write errors and e2fsck freezes the drive.

Silicon Image 3112 - Can't boot from CD. Freezes on the following lines:
ata1: SATA max UDMA/133 cmd blah blah
ata2: SATA max UDMA/133 cmd blah blah

I realize the 3112 was cheap, and the TX2plus isn't fully supported, so I was wondering if any of you guys have had success with a particular SATA controller.