In my years of experience as an auto guy, passenger of many cars, trucks and dealings with commercial trucks, its a mixed bag.
There really is no winning, it just depends on the used. For a small car with a small engine, an automatic just doesnt cut it. You get poor performance and its not too long before you damage the automatic tranny. Ive seen quite a few volkswagon rabbits, etc with 3 speed autos that are just toast after 50-70 thousand miles. Why they use a 3 speed beats me, but then again, why many manufactures miss the gearing for all gears is another mystery.
Like mentioned in another post, a kit can be used to make an automatic behave better and switching out the final drive can make a world of difference as far as drivability of a car.
My folks and myself vote manual. None of us have had great experiences with automatics.
As for commercial trucks, auto ie best. ITs the same down time to rebuild vs replace clutch. Less for a driver with a bad attitude to screw up and even those with no stick shift experience can use. Of course we add a starter interlock, so if the truck is running, you cant grind the starter, cut it off and try to restart and gold brick while the truck is fixed. Just got to tell the guy that this model doesnt have a park option, you put it in nutral and set the parking brake.
The CV trannys look interesting, but if you look at the fuel economy ratings, they still rate less than a stick shift. Just recently, I think a few manufactures have come out with 7 and 8 speed automatics. I can just imagine the insanity of having it shift 3 gears vs the 1 when cruzing down the road. I believe the mercedes e230 the diesel v6 has a 7 speed automatic tranny. Just push the petal to the floor and hear it up shift 6 times as you sit still waiting for the get up and go to hit the road.