effectively, with the current interation of SATA
there is no real performance increase per se with a single HDD
but data reliability is increased, there is a minor efficiency gain
hotswap is supported, cable routing is easier, and the next interation SATA II will support port multiplication, and port selection
the problem is the internal performance of the HDDs themselves
as they dont even come close to employing the current 133MB/s available in PATA 133\100, so bumping that to SATA 150 doesnt really matter much, now more than one HDD is different, as in a RAID array, there it aims at being much more efficent, but can still easily reach a speed matching situation (with a wide enough stripe\number of HDDs) the solution to that is not what you typically see on a desktop mobo, 64bit PCI slots (66\100\133MHz)