The Canon 7D and 5D Mark II can shoot HD video at 60 fps. But with an After Effects plug-in called Twixtor, you can slow the action down to 1000 fps, no expensive camera equipment required. Here's a sample:
Obviously if you're shooting footage of bullets going through playing cards, this isn't going to work for you, but the results look great for slower moving objects like BMX bikes.