Those kinds of frame rates are achieved with specialist cameras capable of frame rates above 500fps.
The Epic comes close at 300fps 2.2:1 sub frame.
The best the AF 100/101/102 can do is 60fps in NTSC mode, and 50fps in PAL. If you shoot interlaced 50i/60i then you can use something like Twixtor to create extra frames to achieve 75-100fps, but this is not always possible.
I agree with Dave.
These tools will work better with interlaced material than progressive, but there is no substitute for high frame rate capture in the 1st place.
And I have had more luck using Twixtor than AE for the times I have had to use it.
If you don't require HD, or very high quality at all, then there are some interesting little compact cameras from Casio that can do 1000fps albeit at a lowly 224x56 frame size. 420fps is better at 224x186, and 210fps at 480x360. Check out http://www.casio-intl.com/dc/ex_fh20/hsmov/ to see some examples.
Yeah if you really want to do it right- rent a Phantom for the day- amazing footage. Otherwise Twixtor from 60i/60p footage is your next bet. RED also has decent slow-mo but still not super dupe slow like the Phantom...
Progressive formats do not work as well as interlaced formats when using things like twixtor. Frames comprised of two temporally different fields assist the programs in creating new frames as the motion shift per part of second is less.
I mentioned before, the Red 1 can shoot at a maximum of 120fps sub 2K, and the Epic can do 300fps sub 2K.
Can I use 60p footage from a 60D and then use Twixtor? Are all Red cameras capable of 300fps frame rate?
60 fps will only get you part-way - and not the "super" slow mo that you see in the above video.
You can use a plug in like the built in TimeWarp, or FOundry's KRONOS to do flow-field time remapping - but me aware that you can really only "double" you fps rate before really bad artifacts come into play.