What's the best automatic gearbox?

I started driving in the 1970s and have always had negative thoughts about automatic transmission - namely slow and thirsty. Clearly the world has moved on and there are some very good auto/semi auto transmission systems out there, but which are the best, and more importantly, which should be avoided? To give some context, I'm looking at buying a medium sized estate, probably about five years old. Any advice appreciated.

Asked on 12 February 2019 by John Ward

Answered by Andrew Brady
I much prefer an automatic gearbox for day-to-day driving, but they can still be problematic. Certain DSG gearboxes used in Volkswagen Group cars can be troublesome, as can Ford's Powershift transmission. CVT gearboxes - popular with Japanese car manufacturers - are generally very reliable, but aren't the most pleasant to use. The dual-clutch transmissions used in Kia and Hyundai models seem pretty robust as does the torque converter used by Mazda.
Similar questions
We live up a steep hill on an unmade road. I do low mileage (6000 a year or so) but have been spoilt with my current electric car auto gear box which is obviously silky smooth perfection! The new house...
Which car brand offers the most reliable automatic gearboxes?
Based on my experiences with the Volkswagen DSG I want a proper old-school torque converter automatic. What do you suggest?