These textures are created specifically for the purpose of adding grain/noise/texture to photos. You can add the texture on top of a photo in Photoshop and set the blend mode to screen.

View Source