I had a 1993 Mazda 323 with 5 speed manual (admittedly hatchback, but there is the Protogé which is the sedan version) and got great fuel mileage (around 40mpg) by advancing the timing a little and hypermiling.
I also got a solid 30mpg out of a 1972 VW Super Beetle.
My best fuel mileage was in my 1985 VW non-turbo diesel Golf (again, there are sedan options if you don't like the hatch).
__________________
|