They are great except for the whole sitting in traffic part. If you plan to spend a lot of time driving in rush hour traffic I'd be over it. But if this is a for fun car, or you don't live in a big city then I'd say manuals are just plain more fun.
Or driving in a city of hills...like San Francisco or Seattle. It's doable...but can be a pita.
I've driven stick for more than 40 years...3 speed floor shifters, 3 on the tree, 4 speeds, 5 speeds, then trucks, , Fuller Roadrangers...9 speed, 13 speed, 15 speed, 12 speed spicers, 3x4 brownies, 4x4 brownies, 4x5 brownies, and 5x4 brownies. (brownies are two stick manual transmissions)
Driving a stick isn't hard...there's a slight learning curve...and one of the most important things to learn is to take your foot off the clutch...except when you're shifting. Clutch plates and throw-out bearings aren't particularly expensive...but if you can't do it yourself, labor is a bitch.