Well I was going to say civic . I find it hard to have all of the qualities you are looking for unless it's high mileage. I far gas economy, I would recommend a four cylinder. You could try:
-Prelude
-Integra
-Legend (v6?)
-MR2 (good luck finding a well kept one)
-Miata
-Mirage
-Corola
-Ranger would be nice