A lot of it is personal preference.
I got my drivers license using a car with an auto trans. All told from learning how to drive until I stopped driving that car I probably drove less than 1,000 miles in an auto vehicle - I've been driving a stick ever since.
But after one bad auto wreck a number of years back that screwed up my right knee (and put my beloved Ranger in the shop), I was relegated to driving an auto trans rental (which happened to be a Monte Carlo with 2,600 on the clock, not a bad car but NOT fun to climb in and out of with a bum knee). When I had to turn the rental in, I drove my auto trans 88 Eddie Bauer BII (much easier to get in and out of).
After having driven an auto trans, I found that it was indeed nice to drive at times. My primary transportation has always been a manual trans, but on the days where I'm driving a stick all day long for work, it is nice to climb into an auto trans to go out for the evening. Just put 'er in gear and go. I'm looking to relax in the evening anyway so I don't really care if it will not outrun a moped.
For work and general driving around, I love a manual trans though. But it's personal preference.