Purchased a 2004 Camry SE with 4 cyl and auto trans, new, and loved it so much I bought the exact same model for my wife in 2006. Consumer Reports describes the ride as that of a more expensive car and they are correct. I have had absolutely no problems with either the 2004 or 2006, just normal maintenance. Hwy mileage is 33, city 24, as long as you drive sensibly and keep tires inflated to 32 psi. My tirewear has gone to normal lengths (25,000 for new car tire; 40,000 for replacement Costco Michelin tires).
4-cyl acceleration equal to my 6-cyl 1999 Chev Malibu and the Camry transmission is smooth, effortless.
2004 model allowed cruise control in D, 3, 2 and with/without overdrive. 2006 disables cruise except in D with overdrive. 2004 allowed full defrost with outside OR recycled air; 2006 forces you to have outside air. I wish they would restore the 2004 choices as we have more options.
† Edmunds.com received the highest numerical score in the proprietary J.D. Power 2014 Third-Party Automotive Website Evaluation Study℠. Results based on responses from 3,381 responses, measuring 14 companies and measures third-party automotive website usefulness among new and used vehicle shoppers. Proprietary study results are based on experiences and perceptions of owners surveyed from January 2014. Your experiences may vary. Visit jdpower.com.