I just see it as:
constant mesh gears with two gears per set (other than reverse) and a clutch (or two) = manual
planetary gears (...except Honda), clutch packs, and a torque converter = automatic
While I prefer a standard 'three pedals and a stick' style of manual, I just have to draw a line at manually shifting automatics. Unless you're driving a drag car with a full manual valve body or something...meh, it just seems lame. At least with DSG and similar tech, you have the argument of lightning-fast shifts while being able to keep a fairly strong, lightweight gearbox. As far as performance is concerned, I think it's the best, hands down.
...but I still don't want it.
And I'll argue for column mounted paddle shifts to my death. If they're the proper size and position, you ain't losing them. In comparison, unless you have ultra fast ratio steering or are going to avoid sharp turns, wheel-mounted ones aren't going to stay under your hands.
Don't even get me started on automatic trans + wheel mounted shifters + up/down switches on both sides of the wheel. Might as well put a wing and some neons on the car.