Depends on the car, gear box, how the software is handled, and what you intend to use it for.
If you're only going to commute in it, and only want the manual to avoid awkward gear selection/changes while going up/down hills, pretty much anything with paddles will suit you fine. Even CVT's aren't that bad, though I've never driven one with paddles. Power utilization is nearly as good as a stick, makes slow cars feel not quite so slow, and I always got a kick out of flooring it and just watching the tach sit at 6500 RPM for 20 seconds straight.
DCT's with paddles are basically the improved manual transmission. You still have clutches, still have the manual transmission basically, but now a computer engages or disengages gears for you. No real hydraulic coupling or torque converter, it's literally just a computer controlled manual. Faster gear changes, more accurate, will never miss a gear, everything that driver error could cause, DCT's fixed. Software and durability can be an issue in some cars - if it's set to preserve the trans life as much as possible, you may not get instant up/down shifts when you want them, as it might lag a touch to avoid slipping the clutch to infinity and shock loading the transmission. Also some cars, like the Fiestas, have constant problems with them. Avoid DCT Fiestas.
Most automatics today actually aren't all that bad, outside of trucks at least. They're relatively good at picking gears, have enough gears to have the right RPM most of the time, are relatively intelligent, and with the right lock up torque converter/programming set up from the factory, can basically split gears to be even more spot-on most of the time.
Trucks are still garbage though. Drove a 2012 Silverado a few times, all the bad things about autos - always changing gears, always in the wrong gear, lag when you smash the gas, shifting up/down at the wrong time - this truck had all of it.
Basically avoid auto trucks. Everything else is fine.