Have you considered the possibility that human vision might have a more-or-less logarithmic response, and that this is why so many graphs related to it use a log scale?[1][2][3]
[1] "Brightness as perceived by the [human visual system] is a logarithmic function of the light intensity incident on the eye.", https://people.cs.umass.edu/~elm/Teaching/ppt/691a/CV%20UNIT... [2] https://spectrum.ieee.org/podcast/biomedical/bionics/does-th... [3] https://learn.sparkfun.com/tutorials/light/visible-light
But what we are talking about here is the wavelength-responses of a particular type of cone cell. Individual cone cells are activated when some photon excites a little protein and causes a chemical reaction. You can read about the details here https://en.wikipedia.org/wiki/Opsin
The spectral sensitivity charts we are talking about here show more or less a summary of how likely that signaling process is to happen for a particular type of cone cell for light coming in at a particular wavelength. To figure out the eye’s overall cone response to some particular light source, you can more or less take the spectrum of the light source, multiply by the spectral sensitivity of the type of cone cell, and then integrate. Notice that that part of our process is linear in terms of the charts we are talking about.
The non-linear part has to do with various types of adaptation which attenuate or discount those cone sensitivities more or less uniformly across wavelengths (for each cone). This doesn’t suddenly make the left part of the long-wavelength cone response more relevant.
In normal circumstances (say, daylight surroundings), a moderate amount of light at very short wavelengths won’t look like much of anything at all, bluish–black, because the cone cells (especially L and M cones which determine red–green response) will be getting much more stimulus from other wavelengths.
If you go to a completely dark room, let your eyes adapt, and look at a blacklight, then you are right that you are at that point going to see it looking purplish because the L cones are stimulated a bit more than the M cones for those wavelengths, and other wavelengths are entirely absent. But this is a really weird edge case for vision.
Why does it say "long-wave" when UV is short-wavelength ?
Now what does this one from [2] mean https://en.wikipedia.org/wiki/File:1416_Color_Sensitivity.jp... (logarithmic scale or not)? The "Red cones" Long line says "absorbance" is higher at 425 than at 450.
This explanation is incorrect.
Your graph is on a log scale.
You can make a camera out of any invertible linear combination of human cone cell responses and you will end up recording basically the same information as far as an idealized human observer is concerned (that’s the basic idea of the CIE system of colorimetry).
The specific choice of computer display primaries has to do with maximizing the possible gamut (as well as other technical and economic criteria), not precisely targeting specific cone cells.
> when you see yellow on web pages, it isn't really yellow
You are using a non-standard definition of “yellow” not accepted by color scientists or color measurement experts.