My friend in Houston's wife has a new '06 Camry LE with the 4 cylinder engine and I was very impressed with the power of the car with 4 adults and luggage aboard. I thought it was a V6 initially, and was amazed it was only the 4 banger. Other than the mountain roads here in BC, the 4 cylinder would be fine for everything else (and probably OK in the mountains also unless you were a power freak like many of us are).
Just a comment.