How can you tell, DSG and 73643374436 speed slushbox are not used since a very long time. 3-4speed slushbox already cost a lot more to rebuild than 5-6speed manual, imagine now with 8-9 even 10 speed automatic trans, they will cost an arm and a leg.
Take for exemple a proven Aisin manual transmission, you can probably neglect it all it's life, never change the oil, run it low on oil in high temperature and it will probably outlive the car. The only place an automatic is better IMO is in deep water crossing, automotive dry clutch don't like water and you can't clutch in if your transmission is under water.
lots of modern automatic don't even have a dipstick, like how the fuck i'm suppose to check if low on fluid or to smell it to see if there is a burn smell, stupid "dealer only" bullcrap.