Why would any want a Metro? We own a Corolla and a Protege and both get great mileage and are incredibly reliable.
If you're looking at price, the Toyota Corolla will be cheaper than a Honda Civic. Mazda Proteges are generally affordable. I'd stay away from new Mazdas as they've gone to crap since Ford took them over.