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.