Interesting. The Spotify playlist didn't do much for me, but when I think of a couple moments in songs that always give me chills, they all feature that pattern:
Nightwish, Ghost Love Score, Wacken 2013 @ 9:22, affectionately nicknamed the "Floor-gasm" by fans. The melody line feels like it's already gone as high as she can possibly go and is just going to descend by a couple notes. Instead she takes it up another 5th to what feels like an impossibly high note, and then holds it there.
https://www.youtube.com/watch?v=47e_961OQWE#t=528
Dream Theater, A Change of Seasons, @ 13:01 and again @ 13:28. It follows one of the odd-time-signatures, chromatic-only jam sessions, and then the band teases an end multiple times starting @ 12:40. When the jam session finally resolves into 4/4 time and the guitar comes in with those held power chords, you're like "Ahhh...." and then just as you start grooving along to that rhythm, the guitars/bass/drums drop out entirely and it's just acapella vocals over keys.