I have driven both manual and automatic cars and as a result am finding the choice of transmission for my next car rather difficult.
I've driven several BMW's with the Steptronic gearbox and actually, it's really rather nice. In automatic mode, the cars are a pleasure to drive around town. It really takes very little effort at all and makes traffic far less tedious.
It also means that when you engage sport mode and stamp on the accelerator pedal at the traffic lights, your car does 0-60 in the time the manufacturer states, every single time, with no brutal clutchless gearchanges required.
And then when you get out onto the open road, slide the car into Steptronic mode. This then gives you manual control over the gearchanges and it is actually very good - it changes more or less when you ask it to, and will hold the car at the redline for a while but changes up of its own accord if it thinks you've forgotten. Excellent.
But... the downsides. Firstly the fuel economy is often considerably worse with the automatic version, secondly there is the worry of repair costs should the box fail - a replacement Steptronic gearbox costs thousands and thirdly although Steptronic is good, and it offers you manual control...
... its not a manual. It comes oh oso very close but just isn't the same as nailing the perfect gearchange coming out of a corner.
Plus you need a proper engine with proper power otherwise autoboxes just suck, and the box needs to be decent. A 2.5 V6 Mk2 Mondeo, for example, a reasonably light car with a potent 170bhp V6, has its performance crucified by the autobox, it's slower than the manual 2.0 16v. As for autoboxes in small engined cars, waste of everyones time.