Via Strong Mocha are 2 video tutorials from Stephan Minning on the new version of his AE filter Normality 3, which was released last month. Minning speaks about the basics of setting up a relighting composition with Normality in AE, along with the various light types, falloffs, and basic shading. Then he dives into rim lighting, toon shading, reflections, refractions, bump mapping, and lighting with a pre-rendered textured object.
Other 3D options in AE were discussed by Lutz Albrecht in his article on texture replacement, etc. at Adobe Developer Connection, Integrating 3D applications with After Effects – Part 1: Working with UV data. More background and links are in the AE Help doc Importing and using 3D files from other application. Here are the Normality tutorials, which can be viewed in higher quality at YouTube:
Update: Smart Normal goes Pixel Bender, and generates a normalmap using condensed(2x2) or sobel-edge(4x4).