You're not going to see any real noticeable performance jumps right now. ATA speeds max out at 133 MB/second. SATA, the maximum is 150, SATA II the maximum is 300.
There are a lot of other advantages to SATA over PATA.
Also by 2007 SATA speeds are expected to reach the 600 MB/sec mark.