I do always say that if you 'ask' about overclocking you're likely not the 'tweaker' for it. There is plenty of information on the web, some of it is even correct!
Its not difficult but you have to understand how things and frequencies influence eachother etc. Its mostly logic though. My experience is, people who ask aren't into it enough to really understand the do's and don'ts.
It really depends on what you buy. If you have low/medium end stuff, there is often a big gain to have. The margin on the 'top of the line' stuff is a lot lower.
My old CPU was a Duron 1400 but it modded into an Athlon xp and did 2500mhz. That is rather worthwhile! My current CPU is an 1800mhz AMD64 that is just as happy at 2500. Worthwhile. However, If I got a 4000+ thingy at 2.6 ghz, I might've gotten 2.9 or 3.0 out of it, not quite so worthwhile..
You have to be nerd enough for overclocking I guess..