I think the most memorable of the Picard-focused TNG stories for me was "Tapestry". It really hammered home how much of one's potential is lost when one never takes risks.
I've always felt very conflicted about the ending of that episode. That to Picard, a life as a reliable if ordinary astrophysicist on the Enterprise was literally a fate worse than death always shocked me, given that I could think of no greater opportunity in life than to be an ordinary astrophysicist on the Enterprise. I understand it was not what he personally strove for in his career, but I always felt a little awkward as he lambasted it.
I've always felt very conflicted about the ending of that episode. That to Picard, a life as a reliable if ordinary astrophysicist on the Enterprise was literally a fate worse than death always shocked me, given that I could think of no greater opportunity in life than to be an ordinary astrophysicist on the Enterprise. I understand it was not what he personally strove for in his career, but I always felt a little awkward as he lambasted it.