I am also retired and in a similar position regarding the need for a newer car. I generally follow the pay cash if I can and drive it until it dies camp for cars. I have a 2009 Toyota Venza 6-cylinder, which I bought new, with 270K miles on it. The body is far from pristine, but not an embarrassment either. I have had it regularly serviced by my trusted mechanic. I followed his advice on what to fix and when. Fortunately, we have never needed major drivetrain repair, but I worry about transmission or major engine repairs in the future. I’m still comfortable putting some money into it for “standard” drivability and safety issues, but I don’t think that I would invest $7-10k in it in one fell swoop. Over the past year, I had to put a couple of thousand dollars into it for oxygen sensors, starter motor, heat shield, brakes, tires, etc., and had to have the dealer diagnosis and fix an annoyingly random car alarm going off (turned out to be a faulty hood latch).
Now, I only use the Venza for relatively short and for relatively less critical trips. For other uses we have a 2015 Subaru Forrester, purchased in 2018 with 5000 miles on it, through my mechanic who was selling it for the proverbial “little old lady” who had now moved to an assisted living facility. That car now has 170k miles on it. At this point, I would still invest $5k or so in the Forrester, and hope for another 50k miles on it.
My mechanic of over thirty years retired and sold his business. We have also moved two hours away. I’m sure that there are plenty of trustworthy mechanics, probably most, out there, but I need to establish a relationship with one.
Our next car will likely be a used certified pre-owned, or at least one that comes with some sort of warranty, likely, a smaller hybrid if we can. I’m not ready to go full electric just yet due to sometime lack of charging station availability, even here in northwestern New Jersey/ New York Pennsylvania area. With both my wife and I being retired, and our schedules being somewhat more flexible, we don’t need two SUVs anymore. I can fit all my gig gear including my upright into the Subaru. We can also fit suitcases and two smaller dog crates for travel in it. Where we live, we still need two cars, but one can now be significantly smaller.
We have had very good luck with both the Toyota Venza and the Subaru Forrester.
I had a pre-diesel-gate VW Sportwagen that I loved, but I will likely never buy another VW after the blatant corporate dishonesty involved. I’ve owned more VWs over the years from Beetles , to Rabbits, Golf, Jettas, Passat than any other brands. They were fun to drive and practical, but not as reliable as our Toyota and Subaru have been.
Good luck in your retirement and car search!