There are two different things to consider here... Colour noise and luminance noise.
In my opinion (and it's only
my opinion), colour noise is your enemy. You should be shooting RAW for higher ISO files, and using decent post-processing software to remove colour noise. Lightroom is very good for this, so is Darktable, and I'm sure plenty of other RAW processors are also highly capable.
As for luminance noise - which is more like the grain we experience with analogue film (though not exactly the same) - you have choices here. You can choose to reproduce your images at a particular size, and on a particular medium, such that viewing from a particular distance means that the luminance noise isn't an issue (the smaller the reproduction size and/or viewing distance, the less noticeable noise will be). This is the best approach if you want to retain as much detail as possible. Alternatively, if you're reproducing images at larger sizes and/or for close-up viewing, you can choose to carry out some gentle luminance noise reduction. I say gentle because a heavy-handed approach is going to obliterate detail and/or give an unnaturally-smooth look to images. Gentle luminance noise reduction will make the noise seem less harsh, and more acceptable at higher reproduction sizes - but you'll still see it, to some extent.
Generally, I'd advise that you carry out colour noise reduction, but avoid luminance noise reduction unless you find the noise intrusive at your chosen reproduction size. In those cases, apply gentle luminance noise reduction only. If that's not enough, accept the fact that you'll need to work with a smaller reproduction size. A great 6x4" image is better than no image at all, right?
Last edited by BigMackCam; 08-20-2018 at 04:16 PM.