Jake and I did the Big Shot at Xmas - he wasn't tall enough for the other two and I was GLAD.
He wasn't crying afterwards, but he was pretty quiet. Like nickbuol said, it isn't the ride, but the ride on top of the height that makes it pretty intense.
Do it at night, too, BTW.
Got the pic of the two of us riding with a couple little terrorists - I'll see if I can find a scanner.