the high end heatsinks are pretty cool, but if you aren't really "into" heatsinks, something like the coolermaster hyper 212 would be more than enough. it's only $30 with free shipping and provides more than enough performance to silently run a quad at 4 ghz.
even the coolermaster hyper TX3, $15 with free shipping, would be up for the job. a 92mm heat tower with 4 or more pipes is really all you need and there's no reason to make a song and dance of it unless you've got a 130W CPU and are going for 4+ ghz. getting a $15 heatsink for a 3.8 GHz tricore has appeal to it, and the $40-60 you save over a noctua/TRUE/V8 or something is another 2GB of RAM or a video upgrade.