I’m responding here before I read any of the other replies, because I’m curious how unique my preferences are.
Personally a manual transmission is all about control. I live in western Oregon, in the Cascade mountains. I have a ~35 mile commute to work (well, I did before COVID…) and 5 miles of that is on the I5 freeway, about 20 miles is on a open 4-lane highway through a valley, and the last 10 miles is on a windy mountain 2-lane county road full of deer and turkeys and bears. Having a manual transmission allows me to downshift and power through corners, use the transmission for braking if needed (just remember that clutches are more expensive than brakes), and when conditions are slushy I can crawl out of the parking lot easier than I ever could when I drove a standard automatic.
For new cars, the choices are essentially a CVT or… a CVT. Manuals are rare, and the other option seems to be DCT, some of which are good, many of which have bad reputations. You mentioned open highway driving. That’s probably where I would be actually be ok with a CVT. But in mountain country that “transmission is slipping” sense I get from a CVT is enough to make me feel like I’m not in control of the car – justified or not. I know that isn’t universal, but it was common enough in the cars that I test drove last year to make it feel universal. There is something about knowing the engine is directly linked to the wheels that gives me a sense of comfort.
There’s also the familiarity aspect. I learned to drive on a manual, every car I owned until I was in my late 20’s (with one 6-month exception) was a manual, and it’s just… what I like I guess.
I could probably get used to a DCT with manual shift mode if I could find one that was reliable. I really wanted a Kia Soul when I was car shopping last year, but their DCT is pretty much garbage, their CVT is standard on all other trims, and a stick is only avaiable on the base model, which doesn’t have cruise control or an arm rest. No thanks!.
The only time I didn’t like having a manual was when I lived in Portland and had to deal with stop-and-crawl-and-stop-again traffic at rush hour. That was a pain in the ass, but it also happened rarely enough that trading the car for an automatic or CVT never crossed my mind. Now I live in a small town and even during the busiest time of day in the busiest part of town, traffic never gets that bad.
And you gotta admit, on a windy mountain road they are actually pretty fun to drive.