I don't know that there are any really "bad" ones. They all have strengths and weaknesses.
Pre-owned, dollar for dollar, the best bargain would probably come down to the '07+ Suzuki XL7 and the '02-'09 Kia Sorento.
Neither has a nameplate known for it's resale value so you can save money there.
The Suzuki is built on the GM Theta platform at CAMI in Ontario. It's the same platform as the GMC Terrain, Saturn Vue, and Chevrolet Equinox.
The Kia Sorento is a traditional body on frame SUV with either a Hyundai 3.5 or 3.8 V6. They are quite nicely appointed for the price and perform surprisingly well off-road (when 4WD of course)
If you need to go cheaper? Cherokee 4.0 or Blazer 4.3.
Better mileage? virtually every maker has a crossover with a 4 cyl. I like the looks of the Patriot and the Tribute.
Maybe, instead of an SUV, what you really need is a small hatchback. They are good on fuel, vastly improved in passenger safety, easier to park, have useful cargo areas (especially with the seats down or reconfigured in the Fit), can be fun to drive, and many look really good. The Fit is the champion of cargo areas. The VW Golf is pricey, but has a fiercely loyal following. The Kia Rio and Hyundai Accent are attractive and better than their predecessors by a mile. The Mazda 2 and Ford Fiesta are well rounded and represent their parent companies very well. The Chevrolet Sonic may well be the first really good subcompact hatchback from GM. The Toyota Yaris seems to be greatly improved. The Impreza can be a little pricey too but has AWD and a following that may actually be more fierce than VW's
The VW and Subaru actually are a bit bigger than the others. Subaru has an excuse. They do not make the inline engine Justy anymore and I read that they were going to cease making Kei cars for Japan. Volkswagen has the Polo but will not market it here. Many believe that is a shortcoming for VWoA but that's another argument entirely.