Theoretically manuals could get better MPG if you granny shifted it. I hate people that accelerate so stupidly slow though. I have low gear ratios in my transmission, so at 70MPH I'm running at around 3200RPM in 5th... It seems really hard to get a manual transmission in a new car anymore. Most dealers stock only autos and you would have to special order a manual.
I swapped a manual transmission in my car this summer. I don't regret this. I used to not ever want to learn to drive manual, but now automatic is so boring. I will never go back to auto. After driving my car for awhile I drove my mom's truck and kept trying to shift and hit the clutch and I became sad when they weren't there. lol I actually made a 2,600 mile round trip this summer 2 weeks after I did the swap. Before the swap I had very minimal knowledge on how to drive it at all. If you are persistent you can get pretty good in 2 weeks like me. I killed it a lot when trying to start in 1st, and did a lot of accidental burnouts as well. In about 1 month I had pretty much gotten over killing it in 1st and starting on a hill, which are the 2 biggest things. Now I don't even see how I didn't get it right because it feels so natural to drive it. Only thing you will hate about it is if you are stuck in stop and go traffic a lot. If you really are just that lazy or incompetent, then just get an auto. It will be safer for everyone. If you don't have access to a manual car to drive, then you will have to buy one. If you already have an auto car, buy a manual as well and drive your auto to work and drive the manual on your free time until you get the hang of it. Once you get it, sell the auto car. In my case, I was able to drive my mom's truck to work until I got the hang of driving my car after I did the swap.