Using this on a Core 2 Duo 3.0GHz E8400 to replace the stock cooler, the fasteners of which had started to break.
The improvement I've seen is absolutely amazing. I've now overclocked my little processor because this has given such amazing improvement. So far I've only been able to push it to 3.7GHz from the stock 3, but that's not due to temperature, just my generally noobiness in overclocking. I am confident that with this cooler I could get past 4.0GHz. I'd certainly recommend this for anyone looking to get an old processor working faster.
Super easy installation, the instruction are minimal (just diagrams), but they suffice. I can't say how easy it would be for AMD set ups, but for intel it is extremely simple. It comes with pre-applied thermal paste, which seemed well applied and is doing an amazing job.
The noise isn't an issue at all for me, I haven't noticed any increase over the stock fan.
Just note, it is quite big. The height shouldn't be an issue for anyone, but it's very wide, so if you don't have low-profile RAM you might have an issue.
Difference in temperature:
[using Prime to get to full load and Core Temp to measure temperature]
Idle - 33*C
Full load (3GHz) - ~60*C
Full load (OC) - Not possible, too high heat.
Arctic Cooling Freezer:
Idle - 33*C
Full load (3GHz) - 35*C
Full load (oCd to 3.7GHz) - 42*C