If you are building a machine with a large window and want one of the best-looking coolers on the market then the Cooler Master Sphere will fill your desires. The Sphere would also work fine for lower power Core 2 or Celeron processors. A standard clocked E6600 would be a good example. Quad Core, overclocked and dual core processors that run on the upper end of the thermal charts are not going to be satisfied with the capabilities of the Sphere.
The mounting system for the Sphere is getting repetitive since so many Cooler Master heat sinks have used it in the past. The first time I ran across it four years ago, I thought it was a pain to install and here I am still talking about it today. So many companies have figured out how to mount a heatsink without needing to remove the motherboard. It is time for Cooler Master to retire this mounting system and turn their gifted engineers loose on coming up with a better solution.