My first DSLR was a Canon 300D. ISO 100 was clearly the best. 200 was very noticeably worse and 400 worse again. I would use 200 or 400 reluctantly if they were the only way to get the shot. 1600 was a waste of time.
Next was a Canon 60D. It was better but ISO 100 was still noticeably the best.
Now, I have a Canon RP and it is very much better. I am wondering whether there is any detectable benefit of 100 verses 200, 400, or even a bit higher. If I want optimum image quality, and other factors allow it, should I still use 100 or would I lose nothing by going a bit higher? Maybe I would gain more by reducing any shake or subject movement with a higher shutter speed than I lose by raising the ISO.
It has been commented that my question seems a bit contradictory and that is reasonable so I will try to explain further.
I am discussing stills not video.
The lighting is good, I have selected most parameters e.g. lens, focal length, and aperture. Now, I have to choose shutter speed and ISO. Suppose that 1/100s at ISO 100 is suitable then so is 1/200 at 200 and 1/400 at 400. Camera shake and subject movement is unlikely so there is no strong need for a high shutter speed. However, the quality loss of going to ISO 200 or 400 is not obvious on my RP (unlike earlier bodies). So, it is a difficult choice.
None of the choices will be bad but which is best is not obvious. I wondered whether the noise might plateau above 100 ISO so I was gaining nothing by going down that low. If that were so, then although there is no strong need for the higher shutter speed, it still might be the better use of the flexibility that I have.