I should probably have added that most of my understanding in gearing comes from bicycles. I fully expect that my limited understanding there will not necessarily transfer. However, it has built up an intuition that gearing makes a huge difference. It is easy to get a sense that the other components of the equation have the final say, but it is impressive the difference going from a mountain to a road bike.
And again, thank you for the responses. I don't know as that I learned anything I can use in making decisions, but I do feel I have at least learned something.
In my experience riding road/hybrid bikes vs. mountain bikes, the lower resistance tires reduce the effort even if the gearing is similar. I'm also guessing the human leg has a narrower efficiency range in terms of RPM and power produced, so bikes usually have 15+ gears.
Now that I think about it, the 'simplest' way to explain the curve is - the vehicle/powertrain variables determine the efficiency curve with ideal gearing e.g. a CVT. If you have a 4 speed transmission, you choose 4 optimal points and imagine a steeper efficiency fall off in between each point (4 flattened parabolas with vertices at the optimal points).
Mayhap I am wrong there, as well.
I'm not an automotive engineer so I don't understand the overall system equations, but I suspect for a given vehicle weight of ~3000lb, drag coefficient ~0.30, and 4-cylinder gasoline motor characteristic that provided sufficient passing acceleration, the "solved equation" for economy cars happens to end up in in the 35-45 optimal range. Gearing can't move the peak so much as make the decline less severe. (In my experience 4 speed autos generally had similar top gear ratios to 5 speed manuals of the time, but had other losses/at in-between speeds)
If you wanted to just shift the peak to the right, you could (1) equip an engine that is very large/extremely inefficient at low power outputs, and had higher parasitic losses and (2) reduce drag. Thus, it would make sense to drive faster, to move your motor out of the extreme bottom right in [4], and "spread out" those parasitic losses over a larger distance.
Adding more gears makes the slope go down less steeply after 40mph (but it's always going down consistently - see the Motor Trend article). The reason I used a 90mph example is I believe most 6 speed transmissions today already have 6th gear optimized for ~70mph cruising due to their motivation in post-2006 EPA testing. By optimized, that doesn't mean the optimal MPG in that gear occurs at 70mph, just that we've eliminated the gearing mismatches/inefficiencies compared to a CVT, which always has "perfect gear ratio". You could still add a 7th and find improvements at 80/90 probably.
So if 5th gear (in a 6-speed) had optimized 40mph, and 40mph is inherently more efficient, we would be driving there instead for overall peak MPG. I was trying to say that with enough gears, you don't need to be in top gear for optimal MPG due to drag. Hope that makes sense