We talking about stability.
Now days overclock's are not usually limited by temperatures, but even if a max temperature is reached the cpu simply throttles itself, it wouldnt cause a blue screen.
Of course a stock cpu cooler wont be very good, but if we comparing reputable air coolers with water coolers, then a high end air cooler is good enough and what is the vast majority of overclockers use.