In my experience using AHCI makes a huge impact once you use software RAID devices - especially when it comes to responsiveness under load.
In IDE mode, heavy IO would have simply bogged down my dual Xeon machines.
w/ AHCI, even while running a tar backup w/ pbzip2, I can still use the machine.
... Though to be honest, I never took the time to benchmark it.
DEV: Intel S5520SC, 2xX5680, 36GB, 5x320GB, GTX470, F19/x86_64, Dell U2711.
SRV: Tyan Tempest i5400XT, 2xE5335, 8GB, 4x2TB, 9800GTX, F19/x86-64, Dell U2412.
VCR: Gigabyte GA-M61PME-S2P, A64/5000X2, 2GB, 1x320GB, 8600GT, F19/x86-64.
LAP: ASUS N56VJ, i7-3630QM, 16GB, 1TB, 635M, F19/x86_64.