I found "The Inner Light" boring as an 11 year old (10? 12?) watching it during the first airing, but when I revisited it on that sampler Blu-ray, I was really, truly moved by it. Little bit of maturity on my part went a long way with that episode. Usually I'm very bored by the episodes where one person either loses their memory or winds up in a scenario where they know everything isn't real or we know everything isn't real. I think part of my hesitation comes from knowing as a viewer that everything will be fine by the end of the episode, and since everything is "fake", we won't really learn a lot about the character either, we'll just get an hour of the lead going "you have to believe me! this isn't real!" (Kind of like the Season 4 episode "Future Imperfect" where right away I don't believe it's really 16 years in the future, so I'm just waiting for the reveal.) What I liked about "The Inner Light" in that regard was that it showed the rest of the bridge crew simultaneously to showing Picard's experiences, so the episode isn't being gimmicky or tricky and trying to force us to believe something that we know isn't true.
"Cause & Effect" is one of my favorites too. I just rewatched that one the other night. Been skipping around the sets in preparation for the Season 6 release.