I know you're playing pretty fast and loose with the story of the games, but yeah...this is pretty off from the games' story haha.This is for the E-Ticket. The land itself is a mix of greek mythology related IP, just like Green Hill Zone is a mix of different platformer IPs and Silent Hill is a mix of different horror themed games. Here's a brief rundown of what I was thinking for God of War barring in mind I know nothing about the series itself so this is basically an interpretation.
You start out sort of like Reign of Kong with a scenic roundabout over the Mt. Olympus showbuilding then quickly drop into the fishing village. This scene is basically the first part of Journey to Atlantis meets the Blue Bayou. Calm, serene, draws us into a false sense of security. You see an AA of an old man Kraken with a long beard in roughly the same set-up as the old man in Pirates, thinking about his glory days of battle. You then enter a docked ship and transition into the flooded ship sequence which is basically a more souped up version of the flooding in Pirates Shanghai. The boats rise to the dock of the ship and we get a HUGE show scene of a vast ocean and a giant two-headed Hydra AA, with Kratos intensely starring it down on the hull of the ship. Super advanced wave machines create real giant waves along with an imax screen, dramatic lighting, and some rockwork on the sides of the room. The reveal is meant to be a huge "WOW" moment.
The boat gets flooded and you transition deep down into Atlantis in much the same way the underwater transition happens on Shanghai Pirates. Atlantis is sort of visually like the Gungan city in Phantom Menace with a lot of emphasis on glowing lighting and a dome placed around it. While we see Kratos and Posiden battling it out on top of a collapsed statue, we also see a "swimming" giant kraken AA suspended between the dome and the roof of the show room.
Caves transition into the River Styx segment which is pretty much a more depressing take on Dead Man's Grotto with "lost souls" instead of skeletons. The Hades thrown room scene has an effect where five or six different Hades AAs disappear and reappear throughout the room through elaborate Pepper's Ghost set-ups. Cerberus is pretty self explanatory.
The fight with Ares and the rock titan is on a forced perspective cliffside of Mt. Olympus. The Ares and Kratos AAs are super advanced with realistic fight choreography. The rock titan is another huge set piece AA with limited movement much like the Hydra, Kraken, and Cerberus. The scene also starts off with a stunt-tronic of Kratos leaping into action, so it's definitely a lot of really high tech AA work saved for last. Overall the general flow of the attraction is Kratos reflecting on the battles he's fought against the other gods. I'm playing SUPER hard and loose with the actual storylines of the games and instead relying on the general formula of Kratos battling a human-sized god in each scene while a giant monster dominates landscape. I'm aiming for REALLY big scale for this. For example the opening fishing village would roughly be about the size of the entire POTC town in scale (from the well to the burning scene).
I like the focus on large set pieces, but honestly I don't think you're going far enough. Until God of War 3, the games were less about fighting the actual gods and more about fighting monsters and weird facsimiles of Ancient Greek things, like the Colossus of Rhodes coming to life and Kratos having to climb it and fight it, or fighting Gaia herself. Maybe instead of a gauntlet of gods Zeus could be the main villain that's pulling the strings and sending monsters down to kill Kratos?
In terms of the story, it might be better to not portray Kratos as a proper hero. The main thesis of the games is destruction and the story is very much played in a way that neither side is right or good. Maybe a better angle to take rather than the framing device being Old Man Kratos reflecting on days past would be to put guests in the shoes of Ancient Greek citizens trying to flee the islands as Kratos continues his assault on the Gods who cheated him.
This is definitely a cool idea. I'm still not sure how I feel about God of War being a water ride, but I think that your Atlantis set up helps make it work better.