If Zelda isn't getting a ride, I could see something similar to Poseidon's Fury working well for the IP. Maybe a special effects show featuring Link vs. Ganon.
A Donkey Kong mine cart coaster would be an obvious pick for a more thrilling ride. Bonus points if the attraction's name uses alliteration in true DKC fashion.
Since people are betting on Mario Kart...is there any hope for a more traditional dark ride for Mario? Basically "Super Mario Bros/Galaxy: The Ride", featuring a Spidey/Gringotts-style structure?