I have to vote for the Mazda 3 as well. Great unassuming car with good engine build quality, cheap to maintain and insure and overall great value for the money. When I was looking for myself, I came across Downsview Auto. They always seem to have a load of 3's that are rust free at great pricing. They have a bucket load of manual trans at or under your price range now.
Buy one of these, do virtually nothing to it but drive it. Have it oil sprayed though.
I'm not sure if I should thank you for the downsview Auto link or not, I can buy a beater (certified) Mazda 3GT manual for about what I spend in two months on gas. Here we go......