I think it's possible that one guy who totally sucks at driving manual can genuinely love every second of it, while the other guy can be flawless at it, basically a pro driver and be indifferent to it or even hate it. This is one of those things that's 100% personal taste, but people can't wrap their heads around it.
Assuming you've driven a manual-equipped car I'm not sure how you came to that conclusion. When I drive one, I don't need to pay any extra attention and I don't even drive a manual that often. When I'd race, it was a bit more involved though since gears mattered as did the shift points. On the road, it's just go up through the gears until you hit sixth, then just cruise along.
I can't disagree more strongly, I'm a big proponent of elston's original point. I've driven manual for 15 years, but have split my driving between a manual and auto for the last 5 or so. The more time I spend back in the seat of an auto, the more I realize that the simple requirement of having to manually shift gears forces a valuable layer of attentiveness into driving. Even though shifting happens as a subconscious effort, you still have to reserve some level of attention to what is going on, what is coming up, where the revs are so that you can be in the right gear at the right time, etc. Obviously this benefit diminishes once you get out cruising steady on a highway for long periods of time.
But that's me. I figured this would apply to everyone, but maybe not. Maybe other peoples' brains simply work differently. Which provides a good segue into the next point..
I disagree with this. A boring car will be a boring car regardless of what transmission is in it. A manual isn't going to make an Accord anything more than a family sedan with a manual, it's not suddenly going to be a driver's car.
Again, I disagree, but this is a taste thing. A manual transmission instantly converts any appliance into a real car for me. And anything without one is at least a little disappointing. A fast car with DSG can be fun, of course. Considering how little time I spend chasing tenths at the track, the fun-factor of a manual holds much more value for me than the performance edge of a DSG. But the options are diminishing, even for the enthusiast. When the F31 3-series wagon finally debuted a few years back, I was basically devastated by the fact that it would only be available in auto. Even my plan B - the new WRX hatch/wagon - was totally wrecked when they withheld the wagon from us. Not that it mattered, as it was never built with a manual in any market.