Guides
Add film grain in DaVinci Resolve
Overlay a scanned grain clip on the Edit page and control it with composite mode and opacity.
Add film grain in Premiere Pro
Use a grain clip on its own track with the Overlay blend mode.
Final Cut Pro and After Effects
The idea is the same everywhere. In Final Cut Pro, connect the grain clip above your footage, open the Video Inspector and set Compositing › Blend Mode to Overlay. InAfter Effects, place the grain layer on top of your composition and set its layer mode to Overlay or Soft Light. Then lower the opacity until it looks right.