Brainstorming part two cont.- another idea

This is the synopsis of the other fantasy idea I had percolating over the weekend:

Lair of the Red Wyrm- Another water dark ride idea, this time D&D/ FRPG based. The guests enter through a queue in an ancient mountainside temple with the back wall collapsed into a cave network. They pass by a wizard who looks up from his scrolls and maps to warn them of the dangers in the caves ahead and the dragon's lair deep below, as well as ride safety. Then they reach the load area, themed as a staging area for the dungeoneering expedition, and board the boats.

After a short ride through the initial creepy cavern, the guests pass a pair of adventurers at a heavy dungeon door. One is picking the lock while the other tells the party to follow their dwarven allies down the stream access. The sound of fighting is heard ahead as they float into a battle between dwarves and kobolds outside the gates of the kobold lair. As the boat gets closer to the gate an explosion topples a rock column in their path forcing them down a side tunnel into the kobold warren. Next are scenes of gem mining silliness with the kobolds. As the guests leave the kobold warren, they enter a large underground cavern with a deep bottom, a series of natural bridges spanning it at intervals. the stream they ride crosses over one while, further in the distance, the dwarves from earlier take cover from gouts of flame coming from something hidden in a tunnel in front of them of them, but projecting a large winged shadow on the cavern wall.

The guests float into the hoard room finally, mounds of gold and treasures piled to the large chambers walls. The adventurers from earlier and some of the dwarves are in the room filling sacks and smiling at their success, congratulating the guests on the success of the three-pronged invasion into the lair. But, as the guests float away from their allies, the chamber shakes, the light turns red, and the air smells of brimstone. A loud booming voice taunts the guests and, as they float towards a strange rock formation in the dim reddish light, it rises to reveal the fanged and furious head of the red wyrm himself. The massive jaws lash out at the boat, but it drops below, falling to safety as the wyrm roars in frustration, and the guests float safely to the unload area.