It was pretty cool. I went with friends, and we got very drunk on a drink called a Warp Core Breach and then did the experience. I remember being impressed at the pacing and the acting of the members running the ride.
This was during the Borg 4D period, and it was pretty novel for the time. A pain to get to from the strip, though, probably part of its undoing.