Not quite as good as some of the uber-modern coasters at dedicated amusement parks (6 flags, Universal Studios, etc) but for an attraction at a hotel its really good!
Worth getting the all day pass unless you're only going to ride it once. I think at three rides you break even or save some money, and the pass is good until midnight. Ride it once or twice, go do some gambling and come back for more!