Western Digital Raptor WD740 - The FASTEST drive out there - This is a 10,000 RPM Serial ATA drive!
Hitachi Deskstar 400GB (7K400) - Hitachi rated #1 in 7200RPM catagory!
Hitachi Deskstar 40-250GB (7K250)
Seagate Barracuda 7200.7 (ST3160023AS)
Maxtor 250GB SATA Ultra Series Kits
Maxtor DiamondMax Plus 9 (6Y160M0)
Western Digital WD Caviar SE SATA (WD2500JD) - (My Drive!)
StorageReview.com "Leaderboard" -> Shows Best/Fastest HDrives...Good forum, too.
A comparison table of fastest SATA 250GB HDs
RAID-0 Striped-Set time table for 4 of fastest drives

SiI (Silicon Image) 3112 Sata Controller - 2 Port
SiI (Silicon Image) 3114 Sata Controller - 4 Port
SiI (Silicon Image) 3124 Sata Controller (PCI-X) - 4 Port
Promise SATA150 TX2 Sata Controller - 2 Port
Promise SATA150 TX4 Sata Controller - 4 Port
Promise FastTrak S150 TX2 PCI Serial ATA RAID Controller (TX2plus) - 2 Port
Promise FastTrak S150 TX4 PCI Serial ATA RAID Controller (TX4) - 4 Port
Promise FastTrak S150 SX4 PCI Serial ATA RAID Controller (SX4) - 4 Port
Promise FastTrak S150 TX4 PCI Serial ATA RAID Controller (64MB ECC)(SX4-M) - 4 Port
The MARVELL Family SATA and SATA II (PCI-eXpress)! Controllers
Adaptec SATAConnect 1205SA - 2 Port
Adaptec Serial ATA RAID 1210SA - 2 Port
Adaptec Serial ATA RAID 2410SA - 4 Port
Adaptec Serial ATA RAID 2810SA - 8 Port
Adaptec Serial ATA RAID 21610SA - 16 Port!
3Ware Serial ATA RAID Controllers (8000 Series) - Up to 12 Ports - $$$ :)
3Ware Serial ATA RAID Controllers (9000 Series) $$$ :) 410MBps! Benchmark - Up to 12Ports

Maxtor White Paper (PDF) describing SATA.
Hitachi White Paper (PDF) describing SATA Interfaces