What is the most reliable transmission for a Ford Mondeo?

I'm looking to buy a used Ford Mondeo and I'm wondering which transmission has the least amount of issues and requires the least maintenance. Any recommendations?

I have been driving my 2017 Ford Mondeo for 3 years now and have had no issues with the automatic transmission. Would highly recommend it!

I have a friend who has the dual-clutch transmission in their Ford Mondeo and they have had several issues with it. I would avoid it if possible.