For the most part, video games ape film and books, so it is not surprising that they follow the dramatic arc. To be honest, most games that have a plot will likely not stray from the familiar formula. Though I would imagine that most games follow the eastern concept of dramatic arc known as
Kishōtenketsu more than Aristotle's version.
Honestly, FFVI follows the dramatic arc rather faithfully.
Exposition - Opening up until the Protect the Esper at Narshe.
Rising Action - The espers are introduced along with Terra's role in the empire's plans.
Climax - Kefka betrays Gestalh and begins the cataclysm.
Falling Action - The Ruined World
Denouement - Kefka's defeat and the ending.
Metal Gear titles don't usually follow the arc, or more precisely, they follow the eastern concept of it, but then subverts it by usually making you do it twice. since several of the MGS games tend to tell two stories (MGS2 -V) or more. Miyamoto has also apparently said he uses this formula for Mario games.
I'm honestly trying to think of a game with an actual plot that doesn't follow the formula, but I'm being brain dead. The only examples I can think of are games that don't have classic narratives based on contemporary form of entertainment like film. Shadow of the Colossus for example, but even that actually falls into the Kishōtenketsu model. The issue here is that as long as the game in question has an actual plot and cast, it's very likely to adhere to one of the dramatic formulas. The only games that won't either don't have a plot, or more likely an excuse plot that never goes anywhere to begin with.