Matt-
When I buy a car, I look at all the models, and yes, like the dork that I am, make a list of +'s and -'s of each. Clearly: reliability, FE, and space are critical.
You seem to trust Honda/Acura as I do, so I can see you in something like that.
Although I just did it, I don't recommend buying a new car -- like Metro said: the depreciation is killer. If you can get your hands on an "Intellichoice" Magazine car listing issue, it will tell you all the reasons why a used car is better, and list every car's value and depreciation over the last few years.
So, we're looking at 4-doors, possibly a wagon/X-over, and Hondacura/Asian (don't feel like you need a wagon/or SUV to haul stuff -- I've hauled 400 lb. of bricks in the back of the '98 Integra - twice and it's still going). If the seats fold down, you can haul stuff. Unless you're a musician or have tall items to carry, I'd steer clear of the wagon-style.
The years are approximations -- see what you can find...
1. 2004 Honda Accord LX/EX 4-cyl manual (leather is an option, I believe) classic "family sedan".
2. 2004 Honda Civic LX/EX manual. My in-laws went from a Grand Marquis to an 05' LX and absolutely love it.
3. New/Slightly used Kia Spectra 5 (make sure it's a stick or you'll get stuck with an old/abused rental car). Good warranty, and inexpensive -- I've driven the sedan and it's will surprise you in a good way.
4. 2005 Mazda 3, 2.0L Sedan or the less efficient Maz 3, 5-door 2.3L. Fun, efficient, word's still out on reliability
5. 2005 Camry -- boring, reliable, spacious, efficient, blah-blah-blah (again, the manual assures "not-a-rental").
The M/V: Built in the GM/Toyota factory in California -- has a GM radio and a few GM parts here and there. Everything else is Toyota. Essentially a Corolla Wagon. Drove a few and the FE isn't realistic to EPA estimates. IMHO it has an awkward driving position and interior layout. I'm not a fan.
6. 2005 Scion xA -- Awesome FE, Toyota reliability, but very spartan inside. The xB is up to you, but we're back to the musician thing again here...
The Prius is way overpriced right now, or else I'd recommend it.
IMHO, avoid Asian nameplates like Nissan, Subaru, and Mitsubishi.
Other makes Foreign and Domestic are your call.
Good luck, and PM me with any questions. I hope things work out for the best, which they generally do.
RH77
__________________