Context is everything!
In very simple terms there are 3 key things that matter:
- CPU architecture
- Clock Speed
- Cores
(it is, of course, much more complicated than that, but is basic terms that's what matters).
Having more cores is obviously better, but only when a program can actually make use of the extra cores. Things like encoding a video tend to be very good at using additional cores and often scale almost perfectly (so the 2 extra cores allows the encode to finish half as fast again). Games, on the other hand, are rarely able to benefit from more cores and often will see little benefit from any more than 2 cores.
Obviously clock speed matters (3.5Ghz, 4Ghz, etc). There are lots of gaming benchmarks (and in fact...