Ironically I believe an American who has never driven a manual would be able to come here and rent one, because (please correct me if I'm wrong) their licences don't distinguish between the two.
I think manuals are slowly on the way out here as well, although they'll persist for a long time on cheaper cars, and a few sportier cars.
A friend's new (automatic) Audi has both faster 0-60 and higher MPG (and lower CO2 output) than the manual equivalent, so manual gearboxes are becoming more difficult to justify, even for petrolheads.