It's not about how much 'noise' you may get, its how 'instructive' that may be to your picture.
If you take a picture of say some-one's face, that's the point of interest; specklie noise on that part of the frame will be far more obvious/intrusive than if its in the back-ground of a fussy bit of wall-paper.
Meanwhile, as said, the cause of noise isn't the amount of ISO amplification on the sensor; it's a whole gammut of factors, a lot of which start in the scene, and the contrast between shades, so if you want to deliberately 'make' noise to see the effect, you need to know what those scene circumstances are and where/how you will get to see them... not just turn the lights down... then, its back not to how much noise you might generate, but how intrusive that may be to the picture you are trying to make.
And we are in to a very very very subjective question, where 'style' and 'genre' are of importance; eg: if the subject is a down and dirty punk band at a pay+play, a bit of down and dirty 'noise' or old fashioned 'grain', could be argued as a bit of effect 'adding' to the 'mood' of the picture; if the subject is a classical cellist? Then that sort of 'dirt' probably doesn't add but detract from the 'mood' and is likely more intrusive and unwanted... and ironically, at the punk-gig, with the performer wearing grungy stage costume, say a chequed shirt and ripped jeans, any noise is likely a lot less noticeable, and broken up, than with the cellist, wearing a plain black cocktail dress against a greater expanse of clean skin, and you have much more contrast and big blocks of very close 'tone'.