Start a hosting plan from $3.92/mo and get a free year on Tuts+ (normally $180)
After Effects, my dear Watson! This tutorial uses hand drawn elements, textures, and pre-matted motion elements to recreate a look that is similar to the Sherlock Holmes credits. It gives you basics to build on. The great thing about this effect is that it is made to look organic and not 3D and effects heavy, but it still turns out looking really professional. It does not require very much expertise in free hand drawing seeing that all you have to do is trace a still image. Take this tutorial and build upon it to create something awesome.