Thanks for this very detailed analysis, Guillermo. I read your full article and came across the following statement, which I found very relevant.
"However, given the low contrast of our test scene, I dare to doubt that said ISO invariance remains so radical in scenes with a lot of dynamic range, where we will have to "raise" much deeper shadows."
The issue of noise, for me, has mainly been about the noise in the shadows. When you shoot in RAW mode, even with a full 'exposure to the right', the shadows are always very dark untill they are lifted during processing. It's that lifting of the shadows that usually reveals significant noise. Such noise was very obvious with the early Canon digital cameras, which is why I used to set my camera to take 3 shots when shooting landscapes, using automatic exposure settings such as -2EV to +2EV. I would then merge the 3 images in photoshop. The under-exposed shot ensured I didn't blow any highlights, and the over-exposed shot reduced the noise in the shadows.
One reason I switched from Canon to Nikon was to avoid this complicated process. With my latest Nikon camera, the mirrorless Z50, the only reason I feel the need to increase the ISO setting is when the circumstances require a faster shutter speed, whilst still maintaining a full 'expose to the right'. Of course, to do this, I use manual exposure.