After Effects is used in many feature films. It's used together with other tools to create and/or composite elements in a lot of visual-effects-heavy movies (like
Sin City,
Iron Man,
Sky Captain and the World of Tomorrow,
Stranger Than Fiction), but it's also used to composite together elements in movies that you don't think of as being visual-effects-heavy. The Emmy award winner for visual effects was
John Adams. Very little in the background in that movie was real. And that was done with After Effects and Photoshop. This year's Academy Award winner for animated short also used After Effects. And, of course, it's used for a
lot of title sequences and closing credit sequences.