For gaming? If so, overclocking for gaming on a Haswell chip, not really. Unless your chip is like Nehalem/Sandy Bridge and still not looking forward to a change yet, maybe overclocking it to 4GHz mark can help in some bottlenecks that you are facing.
Even if you are talking about multi tasking and the above average power users, more cores probably beat higher frequencies. That's why you have those 12/16 core Xeon monsters but they run at 3GHz speeds. And not to mention, dual CPU supporting mobos. Plug 2x 16 core Xeons on that mobo and you have a 32cores/64threads powerhouse to grind whatever you are churning out.
So franking speaking, to me at least, overclocking is something really more of a luxury, and self-satisfaction. For over 90% of the PC users, having a 3.5GHz CPU and a 5GHz CPU doesn't make much of a difference. You still get what you want done. It is like flying Economy class and First Class Suite on the same plane to the same destination. Flying First Class Suite is of cos sibeh shiok. Same as when you got a golden chip and overclocks to 4.8GHz and above for a Haswell chip, that feeling of satisfaction and lanpa song, that's understandable. But you have to evaluate if this is a thing for you and whether the cost is justifiable for you or not.