i think a pre-owned honda civic would suit you well. it's very reliable, efficient and requires low-maintenance. also, civic's handling is nimbler than most of its competitors.
edmunds.com 2006 used car best bet
Yeah, edmunds is a good bet, as is consumer reports.
If you need more room, look at the civic hatchback, not the coupe or sedan.
Also, I just did a quick look at autotrader.com and found about 150 Honda CR-Vs and Subaru Foresters for 6-10k, plus at least one Element in there as well.
The Subaru would get you decent mileage and still have some room in it.