In my opinion the best revision cores, for dual core and single core are as follows, with the number 1 indicating the best core in the category.
DUAL CORE
Dual core E6 (2 x 1MB L2 cache)
1. Denmark core (Opteron: 165, 170, 175, 180)
2. Toledo core (Athlon X2: 4400+, 4800+)
The Denmark core used in dual core opterons IMO just pips first place in best overall OC ability,
Dual Core E4 (2 x 512KB L2 cache)
3. Manchester (Athlon X2: 3800+, 4200+, 4600+)
The Manchester core is the only E4 dual core and has half the L2 cache compared to the E6 dual core. When the X2 3800+ was first released some were utilizing a Toledo core with half of the L2 cache disabled and was therefore an E6 rev X2 3800+, this core usually yielded better overclocks in general. The E4 is a pretty good OCer and is on par really with the Toledo, but as the Toledo has the extra L2 cache and OC?s quite well I would rank the Toledo better.
SINGLE CORE
Single cores E4 (1MB L2 cache)
1. Venus core (Opteron: 144, 146, 148, 150, 154)
2. San Diego core (Athlon 64: 3700+, 4000+, FX55, FX57)
Exactly the same core just different names. However the Opterons are much better overclockers on the average. The new Venice is also supposed to be using the E4 San Diego core with half the L2 cache disabled to equal a total of 512KB, there is no evidence on the overclocks from this core yet, although you would think it would perform quite well.
Single core E3 (512Kb L2 cache)
3. Venice core (Athlon 64: 3000+, 3200+, 3500+, 3800+)
This is the best revision Venice core to date with regards to the overclock ability, but has been discontinued and replaced with the not so good E6 revision (as seen below).
Single cores E6 (512Kb L2 cache)
4. Venice core (Athlon 64: 3000+, 3200+, 3500+, 3800+)
The latest retail version at the moment (until the previously stated E4 hits the retail channel), and this is the worst overclocking core revision on the Venice platform.
Single core D0 (512KB L2 cache, also lacks the latest features such as SSE3 support)
5. Winchester core (Athlon 64: 3000+, 3200+, 3500+, 3800+)
The first 90nm Athlon 64 and is generally considered the least capable, although quite a few reached 2.6Ghz.
All of the above are the latest 90nm core revs. The earlier Athlon 64 were fabricated on the 130nm process which is no longer in the retail channel, and is generally considered the worst performing Athlon 64, although the first FX55 was fabbed on a reworked 130nm process, and this has a stock clock of 2.6Ghz.
More information with regards to the different core revs and other info can be seen
HERE officially on the AMD website