I have tried many types over the years and I think that too many manufacturers try too hard to reinvent the proverbial wheel with auto's. I level this particularly at continental manufacturers, except Mercedes. Currently I am on my 4th pair of Fords in a row. The gearboxes are simple to use and you do not ever feel the gear change take effect. Sport mode available if you want faster take off at the lights but I seldom find it necessary to use it. My petrol Focus with its climate control running 365 days a year avarages between 45 and 48mpg. Diesels? You can keep them.
The gearbox to avoid, IMHO, is the variable type , like the old DAF. They often have a massive lag between foot down and velocity up.
The main benefit is the total lack of any need to keep pressing the clutch pedal to change gear, and this is particularly beneficial when driving in stop start traffic. One pedal makes it go and the other makes it stop. What could be easier.......apart from a self driving car.