I've tried lots of autos and CVTs and still haven't found one that isn't terribly confused about what gearing I want. The worst is when you floor it and it thinks for two seconds before actually downshifting, it can be outright dangerous. And if you're in a powerful car an unexpected upshift that shifts the weight around in bizarre ways, cuts power, and kicks the traction control into overdrive while cornering is a pretty terrifying experience as well.
Some of the paddle shifters seem decent but I often like to change up where I grip the wheel on track days and on sharp turns in mountain driving, so I often can't choose my gearing at all with them.
I can see the appeal of the autos in high traffic tedious commuting situations where you're in some underpowered econobox, which is zero percent of my driving, so I'm sticking with a manual as long as I can keep finding them.