I love my standard 5-speed '05 Corolla S. The handling is great and blindspots small, so it's very easy to own traffic in a good way. Plus, it gets nearly 40 mpg on the highway. One con is its winter-weather driving. It can probably be solved with snowtires or sandbags, but be prepared to slide a little in the snow.
I have never driven a Camry, but Kelley Blue Book user reviews give it 4.4 stars out of 5 versus 4.7 out of 5 for the Corolla. Both great cars, so it'll probably come down to your personality. Are you a practical but aggressive driver (Corolla)? Or are you a relaxed and old at heart driver (Camry)?
www.kbb.com