Daedelic Entertainment are using a great implementation of camera projection in their latest game "Silence, The Whispered World 2" to bring beautiful hand painted scenes to life in 3D;
Develop have an article and video of how it was achieved - Daedalic's camera projection demonstrated.
A longer article is also available on Develop - bringing a painted scene to life