I was fortunate enough to have experienced this, and it was definitely something special. Borg Invasion was fun (if a tad anticlimactic), and the journey from the pre-show to the theater was a nice bit of mini-HHN with the Borg attacks, especially with a great moment of the Borg pulling a crew member up through the ceiling.
As for the Klingon Encounter, that was hands down one of the best attractions outside a major theme park. From the multi pre-shows with a little ride in the mix, to the flat-out journey you take from beginning to end, it was really impressive. Now it also depended on the actors, but thankfully my experience was with a great batch of actors who truly sold the heck out of it, all the way down to the technician at the end who was befuddled how we all got backstage.
And then there's that transporter effect, *chefs kiss*. Easily one of the GOAT's of special effects and it has not been truly replicated ever since. It's one of the few effects that has stunned me, a factor being it's treated as a surprise for maximum effect. And it's also why I'm eternally annoyed by the teleporter effect on GotG: Cosmic Rewind as that effect is botched in every way possible compared to this.