For which park?
IOA-
The best would be Sinbad, but there's really no other big productions.
USF-
1. Horror Make Up Show is very underrated and my favorite amusement park show of all time. A very funny and entertaining show. Also, there's no singing, which is a plus. Make sure you see this one.
2. Beetlejuice would probably be the second best production as a whole. It has some good dance, music, and comedy sequences.
3. Blues Brothers is good for just straight music and nothing else.
As for the other shows, Animal Planet really isn't too impressive. There's no major or even many actual animal stunts invovled. Busch blow away USF for animal shows. Barney is actually a surprisingly good show for adults to endure but the kids will really like this one. Ghostbusters and Streetbreaks are pretty awful and geared toward the ADD crowd who happens to like standing in the sun(half-kidding, but it's half-true as well

). Then again there's folks (see above) who like to stare at the actors and like the show for this reason. For show content though, Horror Make-Up is a sure fire hit, BJ and BB are good for song & dance, and Barney is a perfect one for the kids.