Funny you should mention that. I will be picking up one of the new MacBook Airs and when mulling over the 1.8 vs 2.0 GHz processors, I realized that my last three notebooks (including the new Air) have each had successively lower clock speeds while posting faster Geekbench scores.
2008 - Aluminum MacBook 2.4 GHz - 3374
2010 - MacBook Air 2.13 GHz - 3475
2012 - MacBook Air 1.8 GHz - 6398
Combined with a more efficient architecture, this helps explain the performance gains.
That's true in the low/mid-range market, but the high end is a different story. A Sandy/Ivy Bridge chip with 4+ cores is ridiculously fast compared to everything else. Meanwhile, today's low-end CPUs are no faster than the mid-market parts of 5 years ago.
The gap between the low and high end of the CPU performance spectrum causes problems for those of us who have to figure out what to target with new products.
Processors have barely became faster in the last couple of years. Even a 5 year computer (with some upgrades) is good for doing what 99% of the people do today (internet)
So chances are upgrades today are moot. Unless you're hitting the limits constantly like video editing, compiling software, etc