"The Inner Light." So complete it could stand alone. Picard lives an entire adult life vastly different from his own. Patrick Stewart was the best part of TNG and "The Inner Light" was all about him.
I wonder if there's a name for that kind of story -- I'd like to see more of them. So far, I can only think of the interlude in 25th Hour towards the end.