The Inner Light (1992)
One of the most heartbreaking TNG episodes is also one of its smartest uses of time travel. Jean-Luc Picard finds himself placed in a living memory of a dying civilization, living 40 years as an alien named Kamin in a matter of minutes. It was something that left an impact on the captain for the rest of the series.
