Why not do some research and find the answers yourself?
I'm not real up-to-date on my CPU history, but I can tell you a few.
From what I know, here is my list from best to worst. This may not be 100% accurate, I'll do my best.
Athlon 64 X2
Pentium 4/Pentium 4M
Turion 64 X2
Mobile Pentium 4
Well that's about the best I can do. I'm not real sure how accurate that is, but you might have a starting place that you can research upon.
But, this is kind of hard to do. Take, for instance, the Opteron (one of the dual cores) vs the Athlon 64 X2. The A64 is going to beat the Opteron for gaming, but for server needs, the Opty will smoke the A64. So, in a list of Best to Worst...you need to factor in it's application.