The problem with doubles and triples are 'theoretical' ratios because you really don't ride cross chained. So if you examine a 3 x 8, you really don't have 24 speeds.

Rather should base your needs and focus on your 'effective' ratios.

I'm convinced with a 1 x 11 on my MTB, aided by a clutched derailleur. A key ingredient is the clutched derailleur. Lighter in weight, works flawless, fast, zero chain drop and haven't noticed any chain slap. But the real ~numbers~ is in having ALL effective ratios.

We're already seeing this adopted to gravel / adventure whatever bikes so I would think some roadies will take to the 1 by system. I'm exploring adapting to a vintage bike, a wide ratio 1 BY and using a clutched derailleur.

Also, the made in Spain company Rotor, just introduced a 1 x 13 drive system using hydraulic actuated derailleur. No cables, no battery / electronic. Cool stuff.