A Honda Accord with a manual transmission and a 4 cylinder is reasonably peppy and gets very good mileage.
For 98+, the LX gets the VTEC 4 cylinder, but for 94-97, only the EX has the VTEC. Still, the 94-97 base engine is fair with a manual (no more of a punishment than my 5 speed 102 HP '92 Civic, I can still have a little fun in that car). They last forever (OK, not forever, but well over 200,000 miles not even close to uncommon) with proper care, and they do pretty well with indifferent care, unless the timing belt breaks.
BTW, you should fit as well in an Accord as an Eclipse. But you might just need to go around and sit in lots of cars until you figure out which models you will be reasonably comfortable in. I'm 5'10", so I don't have that problem. I can fit in just about any car ever made.