Morpha in The Legend Of Zelda: Ocarina Of Time.
Canonically causes multiple natural disasters, and is over both the most-infamous Dungeon and the most-popular Middle Boss.
Expectation? A Waterbender Cthulhu. Reality? …A glorified Blue Chuchu, just 1 attack, and can be cheesed in seconds.