I like situations that run into the limit of the ship's power. Like the time the Enterprise-D tried to pull an asteroid or something off course with tractor beams. I can't recall the episode for sure. It might have been the stellar core fragment in "The Masterpiece Society," from what I'm seeing online.
It adds reality when a tractor beam can't just magically move anything, but is limited by the mass of the object in question.