IDE: old and busted
SATA: old and busted
SATAII: new hotness
I have always found Segate drives to be very reliable. Only had 1 die on me, which was a very old 8GB barracuda, and that served me well. I have found Fujitsu drives fail often (at least the older ones), and I've had a couple of Western Digital drives pop too, but had excellent performance from them. Seagate are pioneers of perpendicular magnetic recording too - a new way of storing data which means you get a whole lot more information in a whole lot less physical space.
Best manufacturers IMO are Seagate and Western Digital.
Also, MJ mentioned that new optical drives (cd/dvd drives) still use IDE. Well they don't, everything new has switched to SATAII, but you can obviously still find IDE drives on sale as new. They are probably old stock though.
Martin: for lots of AVI's, you will need a lot of storage capacity. They are generally huge files, and with HD rapidly becoming the norm, they suck up even more disk space. A large cache is also one to look out for, like 16mb. Improves data read and write speed immensely.