I still swear by Zalmans, the CNPS 11 extreme and 12 extreme are impressive coolers. Noctua DH14 and Thermalright Silverarrow are really good but don't fit into every case as well as they look stupid.
For closed loop cooling look at a Antec Kuhler 620 or 920 if you want to pay more.