Let me put it this way, I felt the same way you do now before I actually installed my liquid cooling. Here I am now, never had a problem. If you really want to overclock heavily, get the water cooling. If it is going to cause you to lose sleep, then don't.
There will always be horror stories, but for every one horror story there are hundreds of success stories.