I own a few SUV's, and I am happy with them for the most part, most of the ones that I have owned over the years have been decent, here is my experience with SUVs
2006 Lexus RX330: Love it, great on gas, very comfortable, and good around town or in inclimate weather.
2000 Jeep Cherokee: This is my camping truck, other than an off road weekender, don't waste your money
2004 Range Rover: It isn't really great on gas, and the V8 is lacking in the power department, however it is comfortable.
2005 Toyota 4Runner: This is a great vehicle. It is pretty good on gas, has decent power, and I have had no problems with it what so ever...however it is new so I'd better not have any.
2004 Mitsubishi Endevor: For a "Car Type" SUV this little guy rocked. I only had it for about 18 months, but in that time I put 65,000 miles on it, and it was a champ, good on gas, good in the snow, comfortable ride, and no major problems.
2003 Ford Expidition: Horrible gas milage, but comfortable and powerful
2003 Toyota 4Runner: Again, loved it, no major problems, and decent on gas
2002 Toyota Sequoia: Horrible on gas, has a huge blindspot behind the driver seat, good power and very comfortable.
2002 BMW X5: Loved it, great SUV in every way.
2001 Mercedes ML350: I had more problems with this SUV than any other I have ever owned. In the 6 months I owned it, it was in the shop for about 2 of them total.
2000 Toyota 4Runner: Again Loved it.
1996 Toyota Rav4: Hated it, small, horrible brakes, no power, great on gas though.
1996 Range Rover: Not too bad, horrible on gas but had great power and had no real problems with it.
1994 Ford Explorer: Great truck, worked hard and decent on gas.
1991 Isuzu Trooper: Hated it, POS!
1982 Full Sized Chevy Blazer: Loved it, horrible on gas, but fun as hell to drive, especially with the top off.
Anyhow, I hope this helps, good luck finding something!