I agree with "mech" and others here.  Go for Honda cars.  Obviously, if you are considering Camry, the closest comparison is Accord with the same trim level.

A mechanic told me that he is seeing lot more Toyotas in his garage nowadays.  I don't know whether he was bullshitting me or the mythical Toyota quality/reliability has indeed slid down.  I did read somewhere that Toyota announced loss last quarter for the first time in their 70+ years' history.  However, Honda is stacking profit after profit every period.  Make anything you want out of it, but it probably speaks of Honda's popularity and reliability as well.

CR-V is an excellent buy.  I would look for a 2007 or later model because they came out with new design on that year.  It's close competitors are Subaru Forester, Toyota RAV4 and Nissan Rogue.

Nissan Rogue looks nice inside and out, but when they said that it is based on Sentra, I was turned off.  Plus, Nissan does not show as high as others in Consumer Reports rankings.

Toyota RAV4 would be a good choice.  It even comes with 3rd row seats, although it is for name only.  Anyone over 3 feet tall will have tough time getting in, staying in and getting out from there.  This SUV is larger than its competitors.  But I found it boring to look at, both inside and out.

Subaru Forester 2009 is ranked the # 1 SUV - yes, even over BMW X5, Range Rover and others which are much larger and cost 3 or 4 times more - by Motor Trend.  Even Consumer Reports ranks it at top.  If I were a rational buyer, I would probably choose this one.

But it's Honda CR-V EX that stole my heart.  It is perfect size, fun to drive, looks great from outside, looks great inside, the ride is smooth.  I simply don't have anything to complain.  Hmmmm.... well, I do have one complaint.  Honda does not discount their vehicles as much as others.  But perhaps that speaks well for their product.

So, to make long story short, go for Honda.