Are there any examples of Overpowered characters that never lived up to the hype?

USS Iowa and her Iowa-class battleship sisters (IRL)

The four Iowa-class battleships, USS Iowa (BB-61), USS New Jersey (BB-62), USS Missouri (BB-63) and USS Wisconsin (BB-64) are the most powerful and most advanced US Navy battleships during World War II. However, because they were built late into the war and they were constantly kept at bay from enemy attacks due to the Us navy being too cautious, they never got the chance to have an impressive record compared to older and "inferior" Allied capital ships like HMS Warspite (03), USS Texas (BB-35) and USS Washington (BB-56). Their achievements are superficial, Iowa and New Jersey only sunk tiny destroyers, trawlers and light cruisers in the Truk Atoll, Missouri got permanently scratched by a kamikaze attack and is used as a propaganda tool in movies and videogames, and Wisconsin is memed for shelling a whole mountain of North Korean artillery during the Korean War.

Giovanna Giovanna w/ Gold Experience Requiem (Jojo's Bizzare Adventure)

With GER, Giorno is widely regarded as one of the most powerful characters in manga and anime history. Toxic Jojo powerscalers often say that he would solo all of fiction. However, his best canon feat is beating a street level drug lord with minor precognitive and time-skipping abilities, and then he loses a 3v1 against a reality warper in the Eyes of Heaven game. Considering I already watched shows like Ben 10, Gurren Lagann and Dragon Ball before I even heard of Jojo's Bizarre Adventure, and is familiar with Marvel, DC and SCP cosmology, I was utterly dissapointed that he wasn't the overpowered monster people wank him to be, yet I still see a lot of kids who think he can solo these verses. Giorno's loss in Death Battle's Joker vs Giorno episode was satisfying AF, now everyone can see the tears of the Jojo fanbase can get in the comment section at newest first.