That one is almost easy - look at a KIA
The “almost” bit is that automatics are changing from a true auto with a torque converter to an automated manual with an automatic clutch.
My advice was always to get a diesel automatic.
Then I got a Peugeot 3008 with the automated manual.
OK so it was economical, quite fun to drive, had a wonderful boot, but it did have a choppy ride.
Then, coming back from Manchester, I had about 150 miles behind me when warning lights came on all over the dash, the cruise control lost all its settings, the engine lost power and I just limped into Gloucester services.
We finished the trip courtesy of the AA. A fuel injector had failed. The car had just over 20,000 miles on the clock. The last three Peugeots I have had all had electrical/electronic problems at a relatively low mileage.
It was replaced ith a KIA, 3 years old and with four years warranty remaining.
My youngest daughter had a KIA about 5 years ago and has still got it. New brake pads, new tyres, and an annual service.
That is it!
She drives down from Manchester about once a month to see her aged parents
Look at the Honest John website.
Then look at the KIA C’eed Sportwagon (estate) and Soul (estate). You can get either with a Dual Clutch (automated manual) transmission, and a choice of engines.
If you would rather get a petrol before the diesel cars are totally demonised by the Government (tho’ they do have bigger problems to deal with) then get what you are happy with - but a diesel does have more pulling power at low speed.
The Soul is not very sporty looking, but sells very well in the US.
Others may have a different view.