if you are going to just base it on the transmission... I'd pick the City/Jazz hands down! though it isn't really an "automatic" transmission. very responsive to manual commands (though the 7 speed manual mode is quite tiring).

though as a whole, I'd get the Ford Focus 2.0L Sport. great chassis, adequate engine, lots of kit of a compact car, great styling, etc.