That makes the whole thing much clearer to me, the overlap isn't just between cranks 1&2 and 2&3, it's between 1&3.
In fact there are only 15 "unique" speeds in the range from 27 possible gear combos.
I'm probably overthinking this so I've decided we're going to rent bikes for a day next weekend which I know have 3 x 9 gears and see how we both get on.
Gear range overlap and ratio duplication is pretty much unavoidable with double or triple chainring derailleurs, but can be minimised with careful gearing selection. The trouble is, what you get is what the bike manufacturer thinks will be popular with the "average" rider - which may or may not suit what you want the bike for.
I do think you're overthinking this issue; essentially all anyone needs is a low gear for hills, a medium gear for flat and gentle gradients, and a high gear for riding with a tailwind or downhill. You don't even need mega high gears for descending; once your legs are going round too fast for comfort all you have to do is stop pedalling and freewheel. A top gear in the 90's is plenty high enough for everyone except the speed freaks whose idea of fun is to bomb down hills under power at 40+ MPH.
I have several bikes, with between 3 and 21 gears. Most of the time, regardless of which bike I am riding, I tend to use only a maximum of 4 or 5 ratios. Today I went out for my regular weekend morning ride, and eschewed my 21 speed MTB for a 45 year old 3-speed roadster. Only having three gears, I did use them all, and I used the High gear more than I expected I would, even though it's around 88 inches. The bike wasn't any slower over my regular riding route despite having seven times less gear ratios to choose from. In fact, I actually prefer my 18 speed bikes (3 x 6) to either my 15 or 21 speeds, as to me, six cogs on the back from 14T-28T gives decent spacing whilst being few enough in number to be able to keep track of which gear you are actually in. If you have loads of gears, but maintain insufficient awareness of what ratio you are currently riding on, then you might make a gearchange that makes matters worse not improves things. I'd also question the need to have gears as low as twenty-something inches for everyday use. Yes, if you're lugging a touring load or a week's shopping up a gradient you might need such low gears, but for lightly-laden recreation or utility riding, I've never found much need for anything much below the high thirties. If I find myself trying to climb anything so steep it pulls me down to a walking pace, TBH, I prefer to get off and walk the bike up and over the top to give my legs a rest by using the muscles in a different way.