SATA offers better performance, but it is usually more expensive so, for the casual user, SATA isn't really necessary. While there isn't a huge performance difference between SATA and ATA/133, there is some, and if you require top-of-the-line performance, SATA would be the way to go.
This article appeared in PCReview, and contains some interesting comparative info.