My previous car was my mom's 93 camry dx 5 speed, gets about 28-32 now, used to get a bit higher. Got like 37 on college visits road trip in vermont this summer though. Pretty soon I'll be able to say my former car was an auto crx (I'm converting it to a five speed) hopefully I'll go from 37 to 42+.
My last car was a 1995 Dodge Neon 5-speed. I could consistently get in the mid 40's on the highway with that car. My best mileage with the car was 47 coming home from a trip to Michigan. This was with my wife and two kids and whatever camping gear and clothes I could stuff in. My dad took the rest of it in the back of my grandpa's truck; which by the way is now mine.(1978 F-250 4-speed) Before my Neon I had a 1987 Plymouth Horizon with the 2.2 carbed engine and a 5-speed. I consistently got high 30's on the highway and once got 41 out of it.
Horsepower is how hard you hit the wall, torque is how much of the wall you take with you.
1995 Chevy Beretta, 3.1L V-6 (around 25 mpg)
1990 Chevy Beretta GTZ, 2.4L DOHC4 (around 27 mpg)
1997 Honda Civic DX Coupe 1.6L SOHC(30-40 mpg)
1999 Honda Civic Si Coupe 1.6L "B16A2"(27 mpg)
2003 Mitsubishi Lancer Evolution VIII 2.0L Turbo AWD (18 mpg premium fuel on a good day) Too expensive to run daily.
1999 Acura 3.2TL (25-30 mpg premium fuel) -- Currently own (wife drives it)
1998 Acura Integra LS 3-Door (26 mpg before mods, 30-33 with mods) -- current project car and my daily driver.
Soon: 2006 Honda Civic EX 4-door (30/40 mpg)