Grain can be very effective for certain images. Just look at this gutsy grainy image taken by Sgt Rupert Frere in Afganistan. I believe it was a digital picture, but grain/noise tells the same story.

http://www.flickr.com/photos/defenceimages/6309351435/