I know I’ll get pounced on for saying this but…unless you care ultimately it really doesn’t matter. Sincerely what do you want the end result to look like and how are you going to use the image? I know photographers [professional ones] who purposely use noise as an aesthetic choice. Not on every image mind you, but noise can add mood to your image, so it entirely depends on what your goal is.
Grainy and/or out of focus images can work but it depends on a lot of other elements as well. Keith Carter is one of my favorite fine art photographers and very little in his images are in focus, but he personally happens to like no grain in his images. What matters to me is the emotional impact of an image, I’d take that over digital perfection any day and that is the harder skill to develop!