In the UK you can elect to do your test in an auto, but then you are not allowed to drive a manual, so very few people do.

Personally though, I find driving an auto much more fun. I also have a car with paddle shifters that I never use!