There are several issues to consider here. First, you don’t tell us what years or prices the 7 Camry’s you looked at, or how much over 100k.
I haven’t bought a used car for some time. When I did, the owner provided me with a Car Fax report he obtained. Although it supported his claim it was not a flood car, and was from the source he claimed it was, I have no other experience with CarFax, yet alone this Chipmunk Car Fax. The comments here and the many reviews I see on a search show regular CarFax has horrid ratings. There are tons of flood cars that unsuspecting buyers purchase, and then find out later that they were flood victims.
Next issue: Yes, cars like Toyota, IF properly maintained with oil and filter changes, can go, according to others, 200-300K miles. But what is not being addressed, is that many sellers are selling because they have been told, or they know because they are mechanically-saavy, that as mileage increases, one item after another starts to go - needs a new alternator, major brake work, the computer can go bad, the transmission, items from the whole host of increasing electronics. Even options that have been around for decades, like power windows, power door locks, etc., whose motors can go out, and are often quite costly, or you can’t even find the parts available, except at a junkyard, if the car mfr. has stopped producing them, and if aftermarket sources don’t have them, or have some cheap Chinese junk parts that I’d never put on a vehicle.
Many owners neglect their cars, and are ignorant of any mechanical knowledge. If you live in a climate with cold, snowy winters, the tons of salt that are thrown on roads, eat into your undercarriage and doors and fenders, etc., and eventually render the car useless, where the wheel assemblies attach to the frame, rust so severely that one day a wheel busts off from the frame.
I wouldn’t buy a used car unless it is from the original owner, and that owner has a folder of receipts and paperwork from the original purchase. Those who don’t, I would never trust.
I spent many of my younger and later years looking at used cars, and the same theme was persistent. “I don’t have the receipt” on a brake job, or new tires, or an alternator, etc. when things like this are under warranty. People make all types of claims that turn out to be coverups and lies to sell an auto they want to get rid of.]
And, yes, you should have a mechanic you can trust and who is a top-notch mechanic totally examine the car. If you, like many people, get ripped off on your repairs, and have had parts changed that had nothing wrong with them, you may not know, and are oblivious to the snowjob you’ve been a victim of. And you’d be joining the ranks of the majority of car owners.
IMO, you are much better off buying the newest year used car possible, but researching if that car had engine or transmission or other issues. It’s a lot of work to do so, but this is what you need to do, or you are playing used-car Russian roulette.