I made the mistake of ordering 10-12 (would need to look up the exact number) Transit Connects between 2019-2022 for the fleet at work. So far none have made it to 100k without major powertrain failure.
Transmissions seem to be the weakest point regularly failing between 80-90k. I've already sent 2 off to auction for bad transmissions before 100k, a third for a bad head gasket that the dealer would only put a complete engine in claiming from experience the head and/or block were warped. All 3 had quotes for repair at $9k.
The fourth I actually authorized transmission replacement for at 90k (didn't have a spare truck at the time) just to have it fail again at 101k, it's been in the shop since July.
The fifth died this morning, my driver took it to a national transmission shop that was very responsive and provided a quote in line with the others. Spoke with the service manager on the phone and was impressed with his knowledge and honesty. However, this Connect will be going to the auction, it's just not worth investing $9k into.
I have a 2019 I'm storing at my house with only 51k on it, shifts like crap but it's good for Home Depot runs! A real shame, they are nicely equipped and drive decent which is what sucked me in...along with being $5k less than a full size Transit. BTW, the full size Transits have held up much better, but I had to send one off to auction early for an odd problem where it would die in the rain and multiple trips to multiple dealers couldn't solve the issue. I did one transmission in a full size Transit but it was at 130k - have several others at 200k with no powertrain issues.
We have since switched to GM and my last purchase was four 2025 Canyons, I am confident they'll hold up better.