I'm not overclocking, I don't really know how, but I know it's pretty easy these days. I think I'm rarely CPU bound, only very occasionally, maybe it'd be worth it during wedding processing season.
I'd rather have a quiet PC than a loud one that's 10% faster in the real world.
My day job is as a solutions architect focusing on performance of enterprise systems. We don't get down to the clock speed level though, it's more about number of cores and how they're distributed, what loads what on which machines, architecture of software, etc.
It's definitely going to be more than 10% if it's anything more than a mild overclock. My 2500K is overclocked to 4.0ghz and I'm pretty sure it's more than 10% faster than stock.
Although I do have to agree with you that I would rather have a quieter machine than a loud one. I have optimized my system to ensure that fan speed are a bare minimum. It's actually quite quiet despite overclocking my processor to 4.0ghz. CPU temperature is about 45C.

