We detect noise by seeing it - it's simply there for the eye to see.
I don't look for noise, but when it is there, I see it . . . and it ruins the photo for me. I think it is just so horribly ugly it distracts me from any beauty that might be in the image. Think of a McDonald's bag littering an otherwise gorgeous landscape photo - it would be a terrible distraction that would ruin the photo for most viewers. Well, that's what noise grain does for me. I wish Canon and all of the other manufacturers would find a way to simply eliminate it altogether.

