See also an AE preset from Pixel Art and Curvy Cross Processing in Photoshop CS3 at Layers magazine.
Update: You can't sit on anything... Lester also posted on a text-based After Effects tutorial, Flip-Book Effect in After Effects (includes project) by Jake & Dan. There's a number of other flip projects that are not the magazine book types.
There's a recent example in here:
Making of Adobe CS5 - Production Premium from Seagulls Fly on Vimeo.
Update: Church Media Design helps you create a Magazine Page Flip and how to bend objects in 3D,