It's a pretty good cooler. That being said most AMD Phenom II chips max out in the 4Ghz range no matter what cooling you have. With a custom water cooling setup you might get close to 4.5Ghz out of one if you have a good chip.
probably its slightly below the dual tower coolers of the world and the coloring 12DX is great. Also if it matters the thermal grease phanteks uses is really good close to MX-4 and NT-H1.
You did look at those benchmarks right? That cooler loses to the H60 by 6 degrees in the Tweaktown testing. If you want to do better than the H60 go with one of the high end air coolers like the Noctua DH14 or the big Phanteks TC14.
I don't know without reading some reviews. Read what Ryan did. He explains what fans are best for what application. It's the way they direct air. Some are good for case cooling and some are better for heatsinks.