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.