Giant Kahuna

This ride takes you up a staggering height of roughly 212 ft and then you nearly face-plant into the water below, then do a last minute course correction into an underwater tunnel followed by a short layout consisting of maneuvering around existing attractions, a couple barrel rolls and over-banks, and then culminate into a splashdown.
It uses a slightly edited Seaside Screamer 2 template but I never planned on entering anyway.