From left field here is my narrow, specific recommendation:
2006 or 2007 ONLY Saturn Vue with 4cyl ONLY which is fwd only for these years
I had a 2003 Saturn 4cyl manual from 140k to 260k. It was not trouble free but needs were simple. The Vue got off to a rocky start.
- 02-05 4cyl (2.2L) for automatic was a CVT. A really bad CVT known for failure at 65k miles. Avoid at all cost
- 02-03 6 cyl (3.0L) was the same bad engine that came in the Cadillac Catera. Avoid at all cost
- 04-07 6cyl (3.5L) is the Honda motor shared with the Odyssey but it also has the failure prone auto trans that the early Odyssey had as well. I'd avoid that trans
- 06 & 07 4cyl (2.2L) and a 4 speed auto trans. These final years represented GM finally getting it right (so naturally they then killed it off.)
The 2.2L and 4 speed auto is pure GM parts bin stuff. The engine/trans combo is used in Cobalt, Grand Am, Malibu, HHR, and more. Take that for all that is good and bad about the GM parts bin. For 02-07 the Vue offered a 2.2L and 5 speed manual that I had. Again, these were pure "parts bin."
For a 2.2L with 4 speed auto, the engine is a bit under powered to move the large boxy shape through the air. The result is slow and really not that great mpg. Expect 23 combined. It probably rivals his Escape if it is 4 cyl and certainly beats the Escape if it is 3.0L V6. The Vue is exceptional as an around town car given it useful boxy shape. The car is a bit noisy at hyw speeds. Due to the broke as a joke, I'm assuming he doesn't do a lot of hyw travel/vacationing. Visibility is exceptional. Wide doors, low sills and a near perfect ride height makes egress exceptional. This is the era of Saturn plastic body panels which are great for keeping the car looking rust free but be sure to look underneath. Hood, roof and liftgate are steel.
- I can almost guarantee that if you look at one, it will need a rear wheel bearing. A $25 to $80 part on RockA.
- If there is any rattle from the front end it will be tie rod links (which seem to be made from paper machete) A $3.95 to $39.50 part on Rock A
- If there is any misfire it will be the coil $40-$80 or the ignition control module $40-$90. Back in my day I would buy these used in JYs because the 2.2L was so plentiful.
- Other consumables are parts bin and reasonable price like struts, brakes (f-disk, r-drum). Even the tires are not enormous and thereby expensive like so many vehicles are now.
Quickly sourced samples near you or at least a couple hours near:
'07 w/93k asking $4.6k
'06 w/88k asking $4.5k
Spotters guide of 4cy vs 6 cyl if the ad does not specifically say or show picture of engine:
V6 will have chrome on front bumper looking like air intakes at fog light placement and V6 will have woodgrain trim to dashboard.
Sample V6 listing
I too like CRVs, Rav4s, Scions and Highlanders. But, due to their popularity, $4k examples can be rough. So, the Vue recommendation was an attempt to find a "value" from a dead brand that is overlooked by most shoppers.
EDIT: there was a one year only, '07, Hybrid offered. Avoid due to rarity of parts knowledge and parts availability.