HT1370 - Noise and Human Vision

I couldn't tell you how many YouTube videos I've watched about sensor noise and noise reduction, but it's a lot of them. All of them appear to share the same philosophy: that a photograph is supposed to simulate human vision and therefore have zero noise. But is that philosophical premise really necessary or even valid for a work of art?