Its not really the effects fault, no matter what star trek movie you prefer. Its how the effect scene is constructed. If your into the story enough once the effect take place, you will not even notice that you actually watching an effect.
What that scene you mention fall short for me is actually the music. It doesnt evoke the emotions the scene needs. Compared to the music cues in "Ive got your gun" scene that fits almost perfect, or the opening scene for that matter.