Just from the scale I think it's clear that CRI is not that good a measure. As you say, CRI uses rendition of a dozen or so colors as a measure. The scale is heavily compressed - orange sodium vapor streetlights which are almost monochromatic "achieve" a CRI of 30, which is nowhere near "colors are 30 % good". Similarly, mercury vapor lamps have a CRI of around 50, and yet are complete garbage. All cheap LED fixtures are CRI 80 or 85 which is also garbage. 95 and 98 sounds very close, but aren't.
SSI - spectrum similarity index - is probably a better measure, because it doesn't look at a few colors, but at the entire spectrum, and so heavily punishes peaky and discontinuous spectra as produced by many LEDs. High SSI values also result in much better mix-and-match behavior of light sources. Even CRI 95 LEDs often don't mix well, usually on the pink-barf-scale (tint).
SSI - spectrum similarity index - is probably a better measure, because it doesn't look at a few colors, but at the entire spectrum, and so heavily punishes peaky and discontinuous spectra as produced by many LEDs. High SSI values also result in much better mix-and-match behavior of light sources. Even CRI 95 LEDs often don't mix well, usually on the pink-barf-scale (tint).