I'm in a similar boat. I love my car, I like driving my car, I like working on my car (Subaru BRZ), but if I had the opportunity to take the bus or the train to work, you bet I would. (I COULD, but because the routes are so ass-backwards, it would take me over an hour and a half to ride the bus 12 miles with 2 transfers)
In the spirit of "Cars that SHOULD exist", I'd love me an Autozam AZ1. I grew up playing Sega GT on the Dreamcast, and I LOVED racing that little thing... Or, for a slightly more practical but still tiny and awesome, a Nissan Be-1. I've actually been close to importing a Be-1 a couple times, but the ass-backwards laws that make it difficult to register and drive kei vehicles in the USA are stupid.
Tiny cars are awesome. Big-ass trucks and SUV's in the USA are getting out of hand (I'm sure we can all agree). Just this weekend, I literally exclaimed "What the fuck" out loud when a truck pulled up next to me and the tops of its wheel wells were right at the top of my driver's side window. It was a relatively stock looking new Toyota of some kind and it truly dwarfed my car. I'm used to feeling small, and It might have been because they were passing me on a very narrow bridge, but it was the biggest truck (that wasn't obviously made bigger) I have seen in a long time.