Of the cameras you mentioned, the Sony is the best for that purpose. The Minolta will do 2.5 fps but only for 3 frames. The Canon maxes out at 1.8 fps. The Sony will do 2.6 fps for 7 frames. The question is: Do you REALLY need 8 megapixels? If you want a high continuous drive rate in an inexpensive camera, i.e. not the 1D or D2H, your only choiced might be the Minolta 7i/7Hi (5 Mpix, 7fps at 2 Mpix), the Fuji S5000 (3 Mpix, 4.5 fps at 3 Mpix), or some other less-well-known camera. For example, I think Toshiba might make a 5 fps camera.
Rich is right about the time in the air. Almost all of the sequences I've seen have the rider in the air for about 1 second so just look at the continuous drive rates for the cameras that you are looking at and that number will tell you how many frames you will have in your sequence. Even with 2 seconds of air, which I think would be very rare, if not impossible, you'd only get 3-4 frames with the Pro 1.