SATA (150GB/s) has minimal gains in speed as opposed to the EIDE (133*MB/s max) interface... However, SATA 2.0 which has 300Gb/s rate is slightly faster than SATA 1.0 and there are few chipsets that support it. It would be nice if DVR cards supports more chipsets/AMD. Essentially SATA is a more efficient technology especially SATA controllers with onboard processors.
WD Raptors (10K RPM, 16MB Cache) are quite fast SATA drives.
*: Western Digital does not make IDE133 drives, but Maxtor does... But who wants Maxtor?