You will run into the exact same situation, there are good and bad ones, this goes for every vehicle type.
Yep^^^
To be clear, I still like my Escape, really liked it when we got it 3yrs ago But it is a 12yr old vehicle w 150K. Does what I need it to, when I need it.
And here, in WV the pool of used vehicles is different then whats available to you, there, esp condition.
This has sort of become paralysis by analysis
Get out and get behind the wheel of some cars. May find you like xyz vehicle, just not the 1 you're test driving. Or that you dont like that brand/type vehicle.
You may get a recommendation that zyx is the best vehicle ever made for your purpose. Reality is, the zyx you buy may still have issues. Its used, in your price range, likely well used thru multiple past owners.
Good luck