well it depends on what u r looking for..manual transmission still has some edge in driving performance over auto when it comes to smaller cars..however with the continuous technological improvement in auto transmission, the latest auto transmissions are almost as good as manual..for e.g the newly introduced 5 and 6 speed autos in Honda civic and Accord and Toyota Camry and Avalon are as good as manuals and u do not feel the need to have a manual anymore.
If we look beyond corolla and civic, the availability of manual transmission is extremely limited. for example in mid size cars like the Nissan Altima, Maxima. Honda accord, toyota camry all have 95% sales of auto and hardly any sales of manual. Some of these variants do not even offer manual transmission owing to the refined and satisfactory performance of recent autos.
hence looking at the future developments and the increasing traffic, I am quiet convinced that 4-5 years down the road the sales for auto cars will surpass that of manual..