Segments of most 3d Zeldas are like this, but the one that takes the cake is definitely Majora’s Mask. The entire game is like one bad dream.

Most Metroid games also qualify, which makes sense since they draw heavily from the Alien movies.