My wife and I went several times and absolutely loved the place. The Borg Experience was fun, but the Klingon Ride was more my thing. Loved the shuttle ride. If I remember rightly, the shuttle ride was much more vigorous if you sat at the rear side.
By far the best bit was hanging out in Quarks, trading quips with the actors.
We were back in Vegas in December 2009, and it just wasn't the same without the Experience.