CIEXYZ (CIE 1931) had the best brightness axis ever.
But the hunt for the best color-axis seems to be ongoing.
CIE 1960, CIE 1964, CIELAB/CIELUV 1976...
CIECAM02 CIECAM16 seem to be new iterations. Maybe those are good now?
For blending, linear RGB is a much better choice than HSL. In HSL, a slightly cool gray (230°, 5%, 50%) mixed with an intense warm yellow (40°, 100%, 50%) might create a hot pink (315°, 52.5%, 50%). Not what your eyes expect.
When I was trying to find how close colors are to each other (such as when mapping an image to an existing palette), comparing color distance in YCbCr worked far better than comparing color distance in RGB.
Basically, anyone that paints knows that the more colours are mixed, the more they tend to brown. Yet because of that misunderstanding in the 1960s in Caltech, in CS more colors = white.
Crazy stuff. A great example of technical debt in systems design where we have all this jazz like sRGB, HSL, HSV, etc, trying to reset that basic mistake in physics from 60 years ago.
When you start from a black screen (eg. a monitor) your primary colors that can form all others are literally red, green and blue. Those are the subpixels that every monitor must have as a minimum. These colors will add to white and mixtures of them can make every color humans can perceive (provided your rgb are at the maximum extremes of each color, otherwise your color triangle is slightly smaller than what rgb can actually do). This is called additive color mixing. Start from black and add color.
When you mix paints your are subtracting from white. The primary colors are 45degrees around the color wheel, namely cyan, magenta, yellow. From those you can make alm other colors by subtracting various amounts of the above three colors from white.
Btw do you know what color model matches your eyes the most? It’s additive color mixing. Your eyes literally start by seeing black and as your eyes let in light the cones and rods that are focused around detecting red, green and blue are triggered in various amounts and you see color that way. You don't see color the same way color is formed from mixing paints. You don’t see cyan, magenta, yellow at all. You see in RGB.
So your painting example is really flawed. Subtractive color models are inly useful for paints.
If you don't believe the people telling you about additive vs subtractive mixing, ask yourself this: How does a prism separate a rainbow of colors out of white sunlight? Shouldn't the sunlight be brown for that to work?