I hope to be adding to this section over time, let me know if it's of any use to you.

Sin City Agent Walkthrough
Describing the techniques used in creating the video.

Fake Blood
Using Photoshop, and either After Effects or Premiere

If there's something that isn't clear in a tutorial, or if you'd like some information on a video that isn't covered by a tutorial, feel free to ask. If there is something you think is wrong, let me know!