The main reasons you wanted a manual back in the day was price - because automatic transmissions were expensive - and fuel economy - because they were less efficient. (To a lesser extent reliability, because automatics were newer and they hadn’t worked out the kinks yet.)
However, the price of automatics fell, and the dual-clutch gearboxes with 7-10 gears are even more efficient because they keep the car in the most efficient rev range. Same goes for CVTs. And the dual-clutches shift faster than you ever could, so they’re better for sports cars, which is why F1 switched to them a long time ago.
So it makes sense that manuals are falling out of favor because they’re objectively worse in all respects compared to the transmissions available today. However, subjectively they’re a lot more fun which is why I have a manual transmission car I plan on keeping on the road well into the 2050s.
Fun and more control. I too am in the I bought a manual club. Twice my truck and my wife’s car are both manual transmissions with a clutch (third pedal).
I guess some of the new dual clutch transmissions are considered manual 🤔
I love manuals but while they do give more control than a basic automatic transmission, I don’t think I could argue that they give more control than an automatic with paddle shifters.
For day to day driving, maybe not.
But if I’m trying to to break the back end out, engine brake downhill, or have a dead battery and want to pop the clutch to start it I really want a manual transmission or a sequential gearbox.
I also can rebuild a manual in my garage (and have) so I’m more comfortable with something I can easily service if I need to. I drive 20 year old cars and intend to keep them, and any other car we buy, on the road for decades to come.
A manually-shiftable automatic obeys your suggestion to shift if and when it feels like it. A manual transmission shifts RIGHT THE FUCK NOW as you move the lever.