Those against Auto boxes always seem to quote either old 3-gear boxes from 50 years ago or American cars.
I have owned three automatic cars. The first was a Japanese car, Honda Insight, which was their hybrid and has a1.3 litre petrol linked to an electric motor and a CVT transmission. I never really got on with it, too little power from the engine and a gearbox that had to rev high to get anywhere.
My last car was an American automatic, a Ford Mustang to be precise. This had a three speed auto with overdrive. Ok the gearbox was paired up to a 4+ litre engine with plenty of torque which made it a great combination. Only minor gripe was no engine breaking in overdrive but it was easy enough to switch this off and back of via a button on the shifter.
My current car in German, a Passat Estate with a 2.0 litre turbo diesel engine and DSG transmission which VW bill as semi-automatic.
I'd never go back to a manual but also I'd never so for a small engine / auto box combination again either.
On long journeys I do sometimes find myself looking for somewhere to position my redundant leg left for comfort but I've never stuck it up on the dash
