I got my driver's license in Sweden, and the official driving handbook completely worships manual transmissions, and makes several untrue claims about how much better they are than automatics. You can choose to do your road test in an automatic, but that'll earn you a restriction on your license, barring you from driving a manual. It's probably fair, but almost everyone (myself included) chooses to practice in manual…
I would never want automatic transmission for my car, it's inferior, expensive, less fun and car has no way knowing details of road situation I am facing and choices I am about to make. And I am far from petrolhead person FYI.
Another point - I don't know a single person who has automatic gearbox in their car, not even soccer moms.
Automatic gearbox is faster, and probably better for complete novice drivers so they can focus more on situation on the road. That's it. It is more costly, will wear engine faster, removes some connection between driver and car (includes fun of driving, but not only). Plus it creates desperate and sometimes dangerous drivers when they sit in a car with manual, which will almost inevitably happen.