My 2007 Aveo Hatchback (bought in 2009) has an automatic transmission and I've been very happy with it. It was the car I wanted and the auto trans was just part of the package.

Years ago I had a truck with a manual transmission and I was very happy with that, too. I chose it because at that time the manual was $1,000 less, so I learned fast and enjoyed that truck for years.