Of course, noise is not a desired effect in most cases. However, depending on the circumstances, I would rather have the shot with noise than not have the shot at all. For example, when shooting formal portraits or still life, I would think noise unacceptable because the photog has control over light, camera settings, etc. However, when shooting candids, wildlife, etc., I think some degree of noise is almost unavoidable.
---- "The best camera is the one you have with you."
Pentax K-70 ~ Panasonic FZ1000 ~ Panasonic ZS40