I actually like grain or noise in images, to me it's in fact more real. Why? Because the world is full of texture, unlike than plastic smooth, digital images that have a video quality.
However banding in shadows or colour noise is something I cannot stand. LR/ACR remove colour noise really well leaving just the 'grain' which is fine by me. As for noise removal software, I've never seen any that actually removes noise and retains detail. Usually it simply looks like the image is softer/not sharp. BTW- adding grain to an image is something you can do to increase apparent sharpness/detail at times
Yep, I agree with this. Chroma & patterned luma noise I don't like. Grain-like luma noise not only doesn't bother me, I often accentuate it for effect. Given that photography is for me a creative enterprise, whatever helps me get a look I like or find compelling or even provocative is the optimum
thing to do. Attempts to impose any particular æsthetic or approach as the "right" one should be disregarded.