In between 'That's it? Now I'm disappointed!' and 'WTF?! That's like getting a new GPU!'
3570k (@4.4 ghz, 16gb ddr3 2400mhz) + 980
Just Cause 3
GTA V
6700k (@4.4 ghz, 16gb ddr4 3000mhz) + 980
Just Cause 3
GTA V
Sure, most motherboards do. But auto features tend to apply way to much voltage to your CPU. This results in higher core temperatures than needed. To give you an example. On auto oc my moterboard applies up to 1.38v to my cpu @ 4.6ghz. But by manually tweaking I'm able to get 4.6ghz with just 1.28v. That's a huge difference.
But in the end it's of course your decision. And yes you should definetly invest in a good cooler before overclocking.