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.