This sound comes from Dark Souls, the action RPG released by FromSoftware in 2011. In the game, the cue plays when players enter a newly discovered area and the location name appears on screen. The moment became memorable because of the game's tense atmosphere and punishing reputation, so the sound spread into gaming edits and memes. It is still popular because a single short sting can instantly frame any ordinary reveal as epic, ominous or absurdly important.