"Low noise" is in the ear of the beholder.
I've got a TR Ultra 120 Extreme -- replacing the Ultra-120 original for about a month now.
I bought the Extreme custom-lapped because my hands were sore from modding my case and I decided to "outsource" the work to SVC.
The Extreme brought my 75F-room-ambient load down from 52-53C at a 39% over-clock to about 46 to 47C.  Various concoctions of diamond-powder-loaded thermal paste gained me another 2-3C reduction in temperatures.  I've now stopped "mixing my own" and gone with IC Diamond paste from Innovation Cooling (very likely a "Joe Citarella enterprise" -- he wrote the article on diamond thermal compound in January, and parts of the article were used to promote the product on the company's early web-pages without mentioning his name.)
At stock settings, you'll find that the E6600 will run at a room-ambient around 72 to 76F with ORTHOS load temperatures never exceeding 40C and an average (probably) closer to 35C.  I still have some time-series temperature samples to analyze, but that's what I've seen so far.
Except for the fact that many of our colleagues here -- and they've drawn me into their little spendthrifty pursuits -- tend to exchange parts in less than a year's time, a really good cooler is like a UPS battery-backup -- good insurance and investment in your computer's health.
The Anandtech May 5 comparison of several coolers may give you ideas about alternatives, but the numbers pretty much point to this year's market-winner for performance.
On the noise angle, check out Citarella's heatsink reviews at OverClockers.com.  You'll see that he evaluates a cooler's thermal resistance at different fan-speed settings with noise-level measurements.
Coolers like the ThermalRight line are reasonably and safely effective with fan speeds below 1000 when the machine is at idle, and you can control the fan (through software or other means) to automatically spin up to any speed you want when the processor is "busy" and getting hotter.