When it records at 23.97 and 24 it slows the tape down and records distinct, unrepeated frames at those rates, no built in pulldown.
When you record at 29.97, again every frame is a unique progressive type frame (both fields are the same). To get a "telecine-like" effect you must play the tape out through a capable Sony VTR such as the HDW500 or J3H.
This was the origional specification that George Lucas and others in Hollywood sought from Sony in the development of the camera and it was only later when Panasonic developed their Varicam that the builtin pulldown concept was realized. Since then I think most people understand that it's a great feature toi have, especially because so much monitoring, editing, distribution and exhibition is done in the NTSC environment.