The TNG episode "The Inner Light" is profound. I didn't expect it in Star Trek.
Richard Riehle, the friend in that episode passed on quite recently as well. Was also in Office Space and a fantastic satire about scope creep in projects for the military, of all things.
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.
It's a wonderful episode, always in the Top 10.
I thought it was a lovely version of an ancient idea: https://en.wikipedia.org/wiki/Zhuangzi_(book)#%22The_Butterf...
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.