Dude, even an Insight isnt going to get 80MPG on the highway!
& yes, I know what you meant.
Seriously though, IF you can find one, I suggest a 5th generation (SXV20 A.K.A. 1996-2001) V6 Camry with the 5spd manual tranny. These are solid 14 second cars, and are basically bulletproof in stock form. On top of that, they wont cost you an arm and a leg in terms of repairs/parts, PLUS, 1MZ-FE 3.0l V6 is an engine with:
A) Top notch reliability
B) A ton of aftermarket potential
C) A bomb proof bottom end
&
D) Great fuel consumption
Granted, they aren't the easiest type of car to find, given that most Gen-V V6 Camrys came with the 4spd automatic, but if you can find one with the 5spd manual you have struck gold. These use the same basic transmission found mated to the SW20 MR2 Turbo running the 3SGTE engine, meaning that the shift stick is one solid piece of tech that moves very smoothly through the gates.
Hell, this car even got on Car & Driver's "10 Best Cars" list for a few years in a row. There is a good reason for that.
Furthermore, with the suspension changes built into this chassis design, it is no slouch in the corners. Add some wider/stickier tiers and you have a very nice canyon caver which also has a shit-ton of cargo/passenger room. Further add to the equation with a basic aftermarket shock/spring combo and you have something which will make much lighter 2 door coupes blush. The reason I say this is because my friend has a '99 Camry (4cyl) which absolutely OWNS at the auto-x events.
Besides, TRD also makes a Super Charger kit for these cars.