Definitely the Accord will be better. But with your budget, I guess you'll be forced to get a Civic. Maybe an ESi will fit your budget.

Regarding the A/T or M/T question, City driving i prefer A/T and for long trips I prefer M/T.