Manual transmission depends on the market.
There's plenty of vehicles offered as "Auto-only" in the US that're offered as manuals elsewhere, e.g. Chrysler / Dodge minivans and cars which don't have a manual option in US are sold in UK & Europe with manual boxes.
This is probably because most drivers in US learn to drive in an auto and only a few learn to drive stick.
Only a small percentage of licenced auto drivers then go on to learn to drive stick and there's no requirement (though it's highly advisable) to have any additional training before unleashing themselves on the road.
As I've said somewhere here before though, it's different in UK (and possibly rest of Europe) whereby most people learn to drive in manual cars, as if you don't you're issued a special "Automatic Only" licence and you have to retake your driving test in a manual if you wish to switch. If you get your licence in a manual, you're qualified to drive an auto anyway as there's much less to do.
Automatics, except for those that come only as standard e.g. high-end BMW, Mercedes, Rolls-Royce, etc, are generally the preserve of the old or the mechanically inept and given the extra cost of an auto, plus the poorer fuel economy, especially in most European countries where gas prices are approaching the $8/gallon range (if not more) there's a reason they're not as popular.
I've bought 5 cars in my lifetime, and "owned" another 4.
Of the 5 I've bought, all 5 are/were manuals, and I still own 3 of them, (see my profile page, Miscellaneousness album for pictures of the 2012 Fiat 500 Sport (5-spd) which is
itgirlxx's commuter car, 1995 Mazda Miata (5-spd) and 1981 Porsche 911SC Targa (5-spd.))
The other 4 I've "owned" have been company cars, and unfortunately I don't get a choice of having a manual version, partly because anyone in our company has to be able to drive the vehicle and we can't guarantee they'll be able to drive stick, and partly because the limited selection of vehicles we're offered don't come with manual option anyway. (The 2012 Ford Taurus SEL you can see in that album is my current one, and while it does have 6-spd manumatic transmission with paddle-shifters, it's still not a very entertaining drive compared to a proper manual car.)
I'd currently never willingly part with my own money to buy an automatic car, however, as I progress in years this may change as I lose coordination and reactions due to the inevitable aging process, and perhaps, just for safety's sake, when I'm 80-odd, I'll eventually succumb.
