Great thread, not sure how I missed it the first time around.
Of the fun cars I've owned here is what I remember:
73 Super Beetle, stock suspension, disc brake conversion, balanced and cammed 1641 w/ turbo: What a hoot. Slow, like high 15s slow but it would pull the front wheels up on a hard launch. handling was terrifying, brakes were worse, and the power felt a lot more than it really was. This is the one I miss the most.
77 Plymouth 1/2 ton van, 440ci. POWER! TORQUE! Put 8 bodys in there and give them all whiplash. Hook up a trailer and pass everyone. Burnouts! I miss the old bandwagon, but gas was $4 and I was commuting 45 minutes each way.
84 C4, all stock, automatic, no mufflers: Handling was great, ride height was entertaining. I do not miss that car at all.
90 S10, 3" drop, 4.3, 5 gears, LSD, cat-delete and single flowmaster 40. Torque was impressive, handling was great for a truck, would kick the back out at will. The thing I miss the most was the sound. Snap the throttle shut north of 4000 and bask in the sound.
95 MX6, all stock. Probably the best sound, easily the best handling. Terrible to work on because of neglect and hackery.
93 Accord, stock, auto. Slow, boring, comfortable. Aside from the beetle this is the only one I want back.
Expensive stuff has always been out of reach and so usually out of mind when I try to come up with an answer for this question. The most fun stuff usually seems to have the right balance of cheap, reliable and sounds good. Comfort is of little concern, though I am still pretty young, and power is rarely missed.