There's a moment in the final battle of Breath of the Wild, during the transition into the part that people don't like as much, that stands out to me in this regard
The scene is couched by Zelda talking about this as the final confrontation, the moment of your last triumph. It builds, and builds, and the main theme of the game is playing during this part. If you've watched the trailers you know the main theme. Its crescendo, its climax, is a single note.
"Courage need not be remembered," Zelda says as the final notes play before the end, and in the silence she says: "for it is never forgotten."
And then instead of the one note being the end, it is a transition into the boss's theme, the melody of Cave Theme from Link to the Past used as a bassline for one of the most complex and multilayered pieces in franchise history as you end a war that's been going on for a century
Spectacular