The nine speed Mercedes is about the best I have seen in a car, ZF box in my jap was nice and the 7 speed dry clutch DSG DQ200 although the lowish toque handling of 250 Nm was a bit limiting. Not a great fan of the DQ250 six speed though it was better to have that than the 5 speed manual I could have had in one Octavia but it had the last of the good diesel engines ie the noisy but frugal 1.9PD.
It is all auto for me now as hybrids and BEVs are always automatic but this is the future. EV, one gear, some EVs have two are gather but they are rare. Can crawl along in the single gear, maximum torque come in at 8 mph and it will spin up to over 90 mph, cover the standing kilometer in 30 seconds in serene silence. 7,8,9 speed gearboxes are just another chunk of tech, like the ICE motor, more to go wrong, wear out, cost a fortune to fix, turbos, mechatronic units of DSG, now unnecessary tech IMO to be replaced ASAP.