I've driven a number of automatics, the wife's CVT, and manual tranny's both synchronized and crash box. The automatic I found closest to the control possible with a manual was the (2013 or so) VW automatic. Apparently a close relative of the famed Porsche PDK, I really liked it. Left to itself, it made sure you were in the correct gear for your road speed. And throttle opening.

I'm not a fan of most of the paddle shift automatics. The one's I've driven have a nanny to evaluate your gear ration choice and road speed and decide if the shift will take place.