Spades!! said "Advice from eBrandoners.
Where is the best place to look for a used vehicle?
What questions to ask and information to look for to avoid a bad vehicle (previous accident, mega repairs etc)
I am looking for a small or mid sized SUV. "
Another bit - without knowing what your budget and financial position is - sometimes "mega repairs" are okay if the price is right.
Many years ago, I acquired for very cheap a Plymouth Acclaim (that's how many years ago, LOL) that needed a new transmission at about 200k km on it. I had a rebuilt transmission put in for like $1200 (again, how long ago this was!), plus did a few other repairs, and drove it trouble-free for quite a while until I sold it, with safety, for about the same price I paid to buy it and put the transmission in, essentially making it free to me. The person who bought it drove it for several more years without incident until it finally died, but it had over 300k on it by that point.
So depending on what's needed, sometimes it can be a good deal to do the work and then drive it, especially if it's in otherwise good shape and the price of the repair is taken into consideration.