Great news! How many miles prior did you start to hear the transmission noise? and did the noise change over time? Frequency? Loudness?
I note Ford is using remanufactured transmissions now. It looks like MSRP is around $4800 with the lowest price on internet I saw was just under $4000. One assumes that Ford mitigated the issue causing the early transmission to fail in the remanufactured transmissions. I’m at 132k miles (no noise) and see no reason to trade the car any time soon (now only putting 3k miles per year locally and up to 5k on trips.. So, should my transmission fail, the choices would likely be $4000 + installation - $5500 all in for remanufactured, $3000 / $3500 all in for a used 2016+ transmission + installation, or say goodby to our beloved C-Max.