Personally I do not like the push pin fitting either so when choosing have always avoided .
Am on s775 and started with a Tuniq Tower - good cooler , reasonable noise levels when running at mid speed with pretty blue light. (The reviews on the 'new' one I've read have not been too positive tho)
Moved to the Titan Fenrir - better cooling than the Tuniq but not by much and I found the included fan a bit on the loud side. (found best combo was titan cooler with tuniq fan).
Was intending to stick with the Titan - very impressed with cooling ability at its price

BUT then my case got dropped of a table

and this damaged one of the heatpipes, which I decided involved me in getting a new cooler.
After reading reviews came down to a choice between the Corsair H50 (water) and the Prolimatech Megahalems as both were roughly the same price and performance. As was not ready for 'water' decided to go for the Prolimatech with push/pull apache fans. (total cost approx £70

) and have not been dissapointed.
Am running the fans via PWM and can hardly hear them even when running under load

Would say that the extra fan hardly changed the temps. so would not bother to buy 2 if buying again !
Fitting the Prolimatech was a real pleasure - Straight forward and when complete feels,and I think is, as solid as a rock.
Overall would recomend the Titan - cheaper & nearly as good as the Prolimatech ..... If cost difference is not an issue tho would get the Prolimatech.
If you fancy water cooling then the Corsair gets very good user reviews on here and elsewhere
n.b. Was cooling a Q9550 which was changed to a Q9650 not too long ago.