With After Effects, I tried to convert some of my 29.97 footage into 23.976.
I still have yet to have the source audio included on these videos because I'm not sure if it will sync up, or how to sync up the audio after the video has been altered.

But here are my most recent attempts:

http://www.youtube.com/watch?v=2zS4xTq3khY

http://www.youtube.com/watch?v=48OJfmvjW4s

One of my first trys:

http://www.youtube.com/watch?v=TE46LXOqJcw

For all of these shots, I used a Canon GL2 and Adobe After Effects.

as i steal from someone in another thread... and do not credit them for the saying

it doesn't look like film, but it also doesn't look like video

as i steal from someone in another thread... and do not credit them for the saying

it doesn't look like film, but it also doesn't look like video

Yeah, maybe I shouldn't have said film.
It's more of a personal look of mine. There is more to a film look than trying to convert the frame-rate, and it's something I'll we working on for the time being.

Proper exposure and color correction are 90% of the "film look" assuming outdoor daylight shots. On a set, lighting plays a huge factor. On an outdoor set with lighting rigs, it makes a big difference. The framerate has little to do with the quality of the image. Concentrate on your exposure, lighting, and color correction and you will make quality images.