Get a free year on Tuts+ this month when you purchase a Siteground hosting plan from $3.95/mo
It is mind blowing what you can do in After Effects nowadays and this tutorial is perfect example. This full 3D, fully physics simulated title animation is done 100% in After Effects in a very short amount of time without having to write a single expression or having to do any key-framing ninja work. Even the art-direction is made easy by linking to Adobe Kuler swatches to get awesome professional color combinations.
CS4 is the minimum required version of AE to do this tutorial and it is aimed at AE beginners but any level user should benefit for the workflow tips to do something like this very quickly.