I love manuals, but they have their place. In my TL, it would just be a pain in the rear, since the large motor makes loads of torque. In my Kia Rio, however, the manual transforms the car from an econo buzzbox to almost hot hatch. The difference in driving experience is incredible, more than most cars I have experienced. I love a good manual, and the quality of the clutch and shifter of the Rio have really surprised me, a lot better than my already excellent 2008 Fit.
So I love a good manual in a small car, since it will let that small engine do its best, and make the overall experience a lot more pleasant, for me and pretty much anyone reading this, would fully understand the use of a peppy little manual hatch for brutal city driving.
But that makes too much sense. Most people don't give a good gul durn what they drive, as long as it runs and it easy to drive, and is cheap to run: to whit, we have a gazillion Civics and Corollas on the road in Canada and I'd say at least 90% are automatics. Making manuals mandatory would be a huge waste of time, since 90% of drivers would never use it. I doubt they would even consider a manual car.