My 20 month old, rather adventurous and spirited, was scared his first time through. He did not cry, he just had a look of concern on his face the entire time. By his second and third times through, he enjoyed it more.
As other people have said, it depends on the child.