Bret coming back to WWE is a very underrated "Hell Froze Over" moment. After the death of his brother Owen, the Montreal Screwjob, and not feeling appreciated by Vince for all he had done during his time there, there was almost no way in hell The Excellence of Execution was ever coming back to the company.

Warrior returning to WWE and being inducted into the HoF is a pretty big Hell Froze over moment, after years of issues seeing Warrior one last time in a WWE ring was crazy, and what made it more iconic is he passed away the day after his last TV appearance on RAW, its as if life had given him just enough time to fix things and return one last time.

Sting going to WWF should've stayed a "what if".

A few honorable mentions:
1. Jeff Jarrett returning to WWE to be inducted into the WWE Hall of Fame
2. Ultimate Warrior's return to WWE
3. Scott Steiner, along with his brother Rick, get inducted into the WWE Hall of Fame and is seen taking photos with Vince McMahon and HHH.
4. Randy "Macho Man" Savage kind of made amends with WWE when he appeared in a commercial for the WWE All-Stars video game.

Seeing Sting walk into WWE at Survivor Series was hands down a sight to behold

AJ Styles making his WWE Debut at the 2016 Rumble felt like a Hell freezing over moment. This is a guy who was best known for being a TNA guy and at the time seeing him in a WWE ring was a very surreal sight. The fact that he would go on to become WWE Champion is also crazy that years before people would have been like "Not a chance". Only way you could top that imho is if say Kenny Omega unexpectedly showed up on Raw one week. AJ seemed like one of those guys you would never see in a WWE ring, and whilst we are kind of use to it now, it was almost hard to believe at the time.

Another "Hell Froze Over" moment would be Mickie James appearing in the 2022 Women's Royal Rumble while being Impact Knockouts World Champion. While the Rumble had featured talent from other promotions in the past (though the last time was back in the mid-90s), it had never featured someone who was another promotion's champion. Sure, WWE didn't seem to exactly plan for this (it was definitely more of a "we need more women for this Rumble", likely with a bit of "we also want to make good with Mickie after the whole trash bag incident"), but to see Mickie James come out on a major WWE event with the Knockouts Title around her waist, with "Hardcore Country" playing as her theme, & even getting her own unique name card (though WWE simply called her "Impact Women's Champion") was something I don't think anyone ever expected. All the way up to the event people simply assumed that Mickie would come out to her WWE theme & without the title, with commentary never acknowledging her as an Impact champion, and they were all proven wrong.

Hopefully, one day, this will start to become more of a common thing in future Rumble matches.

Bret lost so much in real life, including his own life he realized that all that anger was doing nobody any good. glad he returned.

CM Punk WWE return, Cody's WWE return, Sting's WWE debut, and Bret's WWE return and making peace with Shawn was Hell Froze Over moments I got to experience.

Sting appearing at Survivor Series was one of the only times in my adult life where I marked out like a kid again.

The phrase never say never rings true when it comes to these moments.

Eric bischoffs return for me was the biggest surprise. This is the guy who started a ratings war against Vince. Literally the competition boss to now working with the company he was facing off against. It was mind blowing to me seeing him but then I realized the power of money. It doesn’t matter what a person does in the past or what he or she says. If a lot of money is on the table it definitely makes you think about what you going to do now.

WCW closing, Austin turning heel, Eric Bischoff joining WWE, & the end of the Undertaker's streak were the most shocking moments in WWE. They will stick in my mind forever

Honestly the true Hell Froze Over was when when Edge Returned in 2020 because for almost 9 years we thought edge wouldn’t wrestle again then at number 21 we heard the opening riff of mettalingus
YOU THINK YOU KNOW ME
& everyone went wild because the moment we all didn’t think would happen Happened

Vince not liking Eric’s business practices is pretty hypocritical of him seeing as he targeted the old territories and put them out of business with aggressive business practices 🤣

Steve Austin wrestling a match, for the first time in almost 20 years.
Simply put, Steve Austin’s illustrious career was cut short because of the lingering neck injury, which forced him into retirement in 2003. Whilst other wrestlers made their in ring returns, Austin stayed out of wrestling. And for years, it seemed less likely we’d see him wrestle again. So you could imagine how shocking and surreal it was that in 2022, Austin would end up not only wrestling a match in almost 20 years, but a WrestleMania match in his home state of Texas.

The Bret and Shawn segment was awesome enough as it was, but it's even better knowing that it was genuine and the two actually had made peace

Sting lost a large chunk of his reputation the day signed with WWE
he was known at the time as 'the greatest wrestler to never sign with Mr McMahon'
regardless of how they used him, weather he would have had a winning streak or the losing streak they inevitably gave him - just the fact he was there, lost him that side of his legascy

I'm surprised you didn't include Edge returning in the 2020 Royal Rumble. That was a huge surprise! He was forced to retire in 2011 due to triple fusion neck surgery, and it had been 9 years since then.

Edge coming back at the 2020 Rumble is definitely one of those moments. I know you can't fit them all in one vid but from retirement to another run.. No one saw that coming.

As a matter of fact, him jumping ship to AEW also! I thought he was a WWE guy for life.

Shawn Michaels' return also. We thought I was a one off. No one knew it'd turn into a second run.