There was one Ds9 episode that i thought was just absolutely amazing. It was about the captain and his son Jake. Sisco, right? Anyway, Sisco he got his by some kind of warp field right infront of his son, which made his dissapear. They had a funneral for him and everything. A few months later, he reappeared in his sons room for a few moments, and dissapeared again. Same thing happened a year later, and then a couple years later. It was found out he was in some kind of time displacement field. Time wasn't passing for Sisco, he was just warping from point to point within moments. One moment, he'd see his son, and then he'd warp, and his son would be married. His son spent his life trying to get his dad out of the field. At the end, his son is about 95 years old and dying, and Sisco appears just as Jake predicted. Sisco has seen over the course of an hour or 2 to him, his sons entire life and his dedication to trying to help his father. Jake figured out that they were bound to each other by some kind of connection, and when Jake dies it'll be all over and Sisco will return to the moment it happened with a second chance. Jake dies in Siscos arms and Sisco is transported back to the moment when he got hit. He dives out the way and none of it happens, but Sisco will always live with the memory of just how much his son loves him.
Crappy description sorry, but it was just really touching and stuff. Favourite ST episode.