I have had dsg and cvt auto gearbox cars and there pro and cons to both really but imo I had no real issues driving them.
Did like the smoothness of the cvt on the honda civic sport i had.
I had to make my move recently to get a suzuki vitara(off the scheme) as the new full hybrid version has an ags gearbox as some have said its automated manual transmission and uselss really imo.
It’s just like driving a manual transmission only worse it having to find a biting point, so is a delay pulling away and it was a big no for me after driving automatic for ages.
Also they go wrong all the time and is a technology that never really took off but is cheaper than a full auto and maybe with supply issues some are adopting them.
What ever you get I’d stay away from those.