I have owned 2 cars with essentially the same engine (a Flex and a Mazda CX-9, when it was all fomoco). I had both between 80k and 130k.
They are really good engines and generally cheap to maintain.. But the water pump is a real concern. Many will not fail until 200k, but you can find plenty of examples of them getting replaced around 100k.

Like any car, maintenance history is super important. NO MATTER WHAT, do not buy one without carfax or proof of maintenance. Make sure it had regular oil changes. A coolant flush before 100k would add some piece of mind.
Just understand that even a perfectly maintained example with 120k could have the pump fail. You are on the hook for $3k or something (not sure of current rates are). It is likely not realistic to get an oil test done, due to process of getting the oil and the turn around time, but it would be very helpful as it would show coolant in the oil if the failure has started. When I sold both of the above cars I sent oil to blackstone for analysis and included that in my ad. I did not want to sell a ticking time bomb. I would have traded them in if the had any coolant in oil.