An episode from DS9 that truly moved me was the one where Ben Sisko is caught in some sort of accident that causes him to leap forward in time over and over, each time seeing his son Jake a number of years older. Jake devotes his life to trying to save his father from the accident. Ben sees the unhappy life Jake lives obsessing over saving his father.
Finally (the moment that most moved me) was the last time Ben sees an older Jake. Jake finds out that he, himself, is pulling his father forward in time, and in order to correct it must die while Ben is present, at just the right moment, so Ben leaps back to the moment of the accident and stays there. We see Jake slip awaw...Ben cluthces him close and says, "My poor boy!"
Wow....