if your not gonna overclock then theres no need. but there are still advantages, such as lower running temps and quieter operation because the cooling is more efficient the fans dont have to work as hard.
if you do get the hyper make sure you get a liquid bearing fan as your guaranteed silent running regardless of the speed its running at.
I personally don't trust push-pin HSF to stay put properly more than 2-3 years since everybody I know with C2D started having high temperature issues due to the retention loosening up over time from plastic deformation.
If you plan to use your system a lot for more than three years, you probably will end up having to replace the stock HSF anyhow.