The 5-speed MT is the only way to go IMHO.

If you go with CVT ( auto ) you might as well go for the Prius and get extra seating room, since the MPG is not that different.

In my 5-speed I get 70 MPG in the city with a cold engine in cold weather without even trying. ( with dry roads. This car sucks with snow on the ground, but that is expected )

On a warm engine, I get 83-85 MPG in the city without doing anything special.
Trying hard and using hypermiler techniques, I'm in the 95 to 105 MPG range.

This car is awesome ( and quite comfortable, that surprised me )!
It's a bit hard to get in and out of being so low to the ground, and well, you'd be better off using the walk-up ATM cause you can't reach half the drive-up ones... but it is quite roomy once you are inside of it.

-John