I drive a bright red 2000 Toyota Echo with a 5-speed manual shift. I bought it new, driving it is a joy, peppy and nimble.
I cannot imagine driving without manual shift.
I really like driving, even in the city, it calms me, almost like meditation. The whole game of shifting up to speed and then down again is a soothing ritual. It is like a dance where you try and keep the car working just hard enough, not too much, not too little, a balancing act.
I drive plenty of automatics, from economy cars like my wife's Yaris, mini-vans now and again for road trips, rental Corollas for when my car is in the shop.
They all work great, and are comfortable rides, but I find them boring and sluggish. The newer vans and cars especially feel so heavy, they use a lot more gas compared to my Echo (it runs at about 5.5L / 100km, or approx 42mpg). They also pamper the driver far too much, I have to turn off all the warnings!
When I drive my car, I definitely feel the road much more directly in how the car handles, can feel directly how hard the engine is working, am so much more aware of the driving experience. It engages me completely, and I enjoy it very much.
I had to use a courtesy car one time, automatic of course, when my car was in the shop for a few weeks. It worked fine, blah blah. When I finally got my car back I ended up driving all over the entire Vancouver lower mainland for about 4 hours, just reveling in the experience of zipping around in a fun car, shifting and being in tune with it.
I love my car, and will grieve when it finally goes.
I have my eye on the new Toyota Corolla Hatchback, which is relatively reasonably priced, and is fortunately still available in manual for me in Canada. Fingers crossed though that I get at least 5 more years out of my beloved Echo.