My favorite workhorse was a 99 Silverado with a 5 speed manual and 4.8L engine. 1st gear and low range and it was a crawler. Pulling a loaded car trailer was no problem either (3rd gear over hwy 58 to Mojave at 70 mph easy peasy). I got way more work out of the 4.8L/5 speed than my later 5.3L/ 3+OD automatics. More gear choices the better. But as I said earlier, although I have not driven many high gear count autos, the ones I did sucked simply due to poor programming. But.... if control is right then experience says the more gears the better for crawling, hauling, accelerating, and cruising.
Reliability of modern high gear count transmissions is my only question. Each time an automatic shifts, to make the transition pleasant, it slips between two gears for a moment. This builds heat and is the wear point. Us old guys are used to installing shift kits to speed the gear changes up, and if we don't go too stupid with it performance and reliability are greatly enhanced. With a high gear count, the transmission is shifting many more times per any given activity than a low gear count, resulting in increased heat and clutch disk wear (or so I would think, anyhow). How is the reliability these days? A few years is one thing, but I am used to running 15-30 year old vehicles and offering them no mercy.
So my question to those that drive and stress modern vehicles is: Is the reliability on par yet with the traditional workhorses (TH400, 727, C6, etc)?
IMHO- My ideal gear count is 7 gears. 1 granny, 4 speeds ending in direct drive, and a double overdrive. Make me one as strong and reliable as a TH400 with solid programming, and any gas engine I am likely to be interested in will come alive with it.