There are a lot of previous topics on this. Do a search on topics with "auto" in the title.
Cliff's Notes version: If you want a manual, buy a manual. If you want an automatic, buy an automatic. Don't buy an automatic because you think you might save money on the purchase.