The TNG episode "The Inner Light" is profound. I didn't expect it in Star Trek.
Yes it's my favourite too. For some reason I had set the VCR when it first aired and I'm really happy I did.
I learned today that the son in that episode is Patrick Stewart's son.
A really beautiful episode and apparently one of his favourites. That moment at the end where he realises what's happening - "Oh, it's me! I'm the one it finds!" - so touching and such a wonderful performance.