What does SATA buy you?
On a single drive, when you get cache hits, you get the full bandwidth, eg 150MB/s. Most of the new SATA drives have 8MB cache, so this can be a significant increase in performance.
The real advantage comes with a two (or more) hard drive system.
Take, for example, a system running PATA100. Each port (primary and secondary) is limited to 100MB/s. In reality, this is moved down to 89MB/s due to overhead in the protocol. So, if you have two hard drives connected to the same cable, then you are limited to 45MB/s when you are copying files between the two drives.
And no, you don't want to put one drive on one port and the other drive on the other port, because you'll want to put your DVD drive on one of the ports. This will drop your speed down to ATA66 or ATA33 most likely, because that is as fast as the DVD drive can go.
Since there is one cable per drive, you get the full bandwidth on each cable. In a RAID 0 system, the change is dramatic.
HTH.
-Steve