Pretty much the whole of TLOU, one way or another. I still reckon Winter is the best level/chapter/sequence I've ever played through in gaming. From the first time you meet David you know something is wrong, and when you talk to the other members of his faction both their accommodation with what they have done to survive and David's proclivity...yes, it's been done before, but not in a game and rarely as well.
The giraffe got me more in the context of what's around it - coming out of Winter and what then happens in Spring. If anything it was more impactful on my second playthrough as this oasis of peace & simple joy.
UC4 is the same - it's underlying themes of deception & family are done incredibly well, and are implemented in all the character backstories, including Rafe & Nadine which, are brilliantly woven together into the moments people have linked to. I remember a prelaunch interview with Neil saying that there weren't as many bombastic set pieces as previous entries in the series, but smaller, more intimate ones and they absolutely delivered on it.
My other highlight is Nate in the desert in UC3. The whole sequence from the airport through to the plane crash ending in this contemplative sequence