I've driven good autos and I've driven 3 Focuses with the DCT and it's a so-so auto and is pretty good when it's got things worked out but the driving experience IMO was a bit boring and needs a proper manu-shift type stick instead of a little toggle. One of the best autos I'd driven was the 6 speed in the Mazda MX-5.
'12 Focus Red Candy SE Sport 5 spd
'99 Toyota 4Runner Sport
'11 Subaru WRX STI Hatch