Well when comparing processors you have to look at more then GHz also.
You have L1 cache, L2 cache, L3 cache, Front Side Bus (FSB) speed, etc.
So it really depends on what you're comparing.
The numbers will show in benchmarks, probably not so much in a real world environment.
Here's what seems is a pretty good article about dual core performance.
http://www.tomshardware.com/reviews/single,1165.html
But the thing is software isn't quite there to make the most potential out of multi-cores. You have to realize this is a huge change for personal computing, the software will be the last to catch up.
A bit off topic:
It's sort of why the idea of a PPU, or physics processing unit didn't really take off. GREAT idea, you buy an addon card for your desktop computer, it controls the physic calculations of a computer game taking a great load off of the CPU. However, very few developers have pushed their games to utilize this new piece of hardware. PPU cards are fairly expensive and new, and I believe is also proprietary to Nvidia. So anyone owning an ATi video card CAN'T use the PPU card. So why on Earth would a game developer want to cut off potentially 50% of the market from being able to run their game?
But the PPU is still around and I think it will go somewhere, software developers will learn how to utilize it better, along with multi-core processors in the consumer market. It just takes time.