It seems to vary depending on the particular model, but I've seen more dead Maxtors than any other drive.. The older Quantums seem to be bulletproof (still know of an old 52 megger that works fine) and I personally use Western Digitals these days and have no complaints. Seagates now have 5yr warranties so they're probably decent enough.
As far as older drives I try to avoid any that have that nasty metal on metal sounding whirr when they're running, or anything that goes clickety-clickety-clickety randomly

I think the biggest thing is to keep them as cool as possible and make life easy on the bearings and the electronics. Oh and don't hot-plug anything onto a power cable that's also connected to your HD. Don't ask me how I know... :-o