This is not the problem. ALL movies are shot in 24 frames per second - it's the rate film is recorded as an industry standard. ALL films are then converted to 29.97 fps - it's a process called 3:2 pulldown, and it is done all the time every day. If this was the problem, then all GhostRider DVDs would also exhibit this problem, since all DVDs are also converted to 29.97 fps (for north American NTSC anyway).One possible explanation for these quality problems could be framerate conversion. TiVos only support video with a frame rate of 29.97fps. Some movies are actually filmed at 24fps. That means that Amazon has to use some sort of framerate conversion to make them compatible with TiVo. There are various methods for doing framerate conversion, and some work better then others. These sort of motion artifacts are actually characteristic of some of the poorer techniques.
If it is a framerate conversion problem, then it would explain why it only effects some movies as only some use the 24fps "film mode".
The more likely explanation for this problem is simply that the Tivo hardware can't keep up with the motion-intense bitrate of these scenes, since they are almost certainly encoded at a variable bit-rate. As the complexity of the scene increases, so does the bit rate. You will sometime see these problems in low-end DVD players for the same reason, and is likely the reason you see it in other cheap hardware.