While there may be tutorials out there that go into greater detail, it seems to me there are some basic ways to make CG animation look more like film:
• 24 frames/second
• motion blur
• depth of field blurring
• film grain
Any one of these techniques will help CG footage look less computer generated. Using all of them will push the look even further.