My primary car has always been MT. Something like 7-8 cars now. I did have 2 beater trucks over the years that were auto, but those had limited uses. MTs are getting nearly impossible to find in anything beyond a few base cheap cars. Especially on used market. Even if nominally they are available. Performance cars are practically all AT or DCT now. Even Porsches pretty much have to be ordered with MT(and not even all 911 models have that option). Same for BMW.
Last car I bought(CTS-V) took about 3 months to find and it was 8 hours away. All because of MT. Every time I look for a car I go through the same agonizing routine. "It would be so much easier to get an auto... They are faster(in cars I like), cheaper, easier to find, better in traffic, smoother..... This car is great, I love everything about it, but it's only available with AT" And then I go drive one. 5 minutes and I'm frustrated as hell. Some ATs are better, some are worse(more gears only makes that worse generally). DCT is awesome for track use. My wife's little DCT Hyundai is actually rather nicely setup. But in the end, the car does what it wants, not what *I* want. And I can only deal with that for so long.
Last year we bought my wife a new car. Hyundai Veloster. At the time, I asked her if she wanted Auto or MT. She didn't know how to drive MT but was always interested in learning. I said that I could teach her in a week or two. She was too afraid and opted for DCT Auto. I obliged. It is actually one of the nicer DCT setups I've encountered. Later that year I tried to teach her driving MT on my car a couple times. All resulted in frustrating failures. Heavy car, tricky clutch-- just too difficult to pickup from 0. So it looked like a good decision.
Fast forward to this year. We borrowed my friend's beat-up 5sp Mazda. 15 minutes on the parking lot and she was rowing through those gears like a champ. I was truly impressed and proud. A few days later, back in my car --not a single stall. We get home that day and she tells me that we should have bought MT for her. DUH!!
Oh well.... I'm keeping my car as long as I can