Soundwise the quietest is an old Seagate model. But the Samsung SpinPoint series appear to have taken over that crown, while at the same time providing good performance, so I bought me one of those and set it to "quiet".
Can't say I hear it spinning, but then again, can't hear anything over the noise my old 40G Maxtor makes.