I converted the paintingmy daughter did into a height mapped terrain. Then I selected one row of verts (with Alt+Shift+RMB), duplicated them, seperated them, raised them above the terrain and converted them to a curve. The camera was moved and rotated to the head of the curve and parented to it using ‘Follow Path’. CurveFollow is turned on so the camera rotates with the ups and downs of the path, but the rotations are too extreme. I can lock the Y and Z rotations.
Is there a way to limit the rotation of the camera on X to a certain range like you can with bones?
If you have a strong stomach, you can check out the rendered version below. I made a more interesting curvy path and slowed it down.