Scott Steiner made his return to WWE back in late 2002 after having an excellent main event run in WCW. He had been a former WCW World Heavyweight Champion. He had also been a triple crown champion in the promotion. No wonder WWE had high hopes for him when he was signed by the promotion in 2002.
Only a month after returning to WWE, he started a feud with then World Heavyweight Champion Triple H. He was awarded a match with Triple H at the Royal Rumble event of 2003. Steiner won the match via DQ but could not win the tournament. However, Steiner completely destroyed Triple H in this match.

Scott Steiner explains why his WWE return did not work
‘The Big Poppa Pump’ was given a rematch for the World Heavyweight Championship at the very next event which was No Way Out. This time, Triple H pinned Scott Steiner to win the match and retain the title. After this defeat, Steiner totally lost his main event push.
Scott Steiner is a former WCW World Heavyweight Champion
‘The Big Bad Booty Daddy’ remained under contract with WWE for the next couple of years but he was given a lower mid card treatment and he completely lost his main event push. Recently, Steiner remembered his failed second WWE run and discussed what went wrong. Speaking with "The Wrestling Classic," he explained;

Scott Steiner returned to WWE in 2002
"I wish I could have been healthy. My foot was totally paralyzed, you know, that was before I got the surgery on it. So, you know, if I try to watch a match now from back in that time, I mean, I can't even watch myself walk to the ring. It was just, you know, experiencing paralysis is a messed-up thing," he continued, "And I mean, it's still paralyzed to this day, but I had surgery to kind of stabilize it — a little bit more than it was. But still, you know ... yeah, still dead," Steiner said.
Check out why Scott Steiner's nephew Bron Breakker joined forces with Seth Rollins here
After his departure from WWE in 2004, he went to the Independent Circuit and then to TNA Wrestling in 2006, where he received a mid card push. Steiner is not active in the wrestling world and he is considered a legend of professional wrestling. He was inducted into the WWE Hall of Fame along with his brother Ric Steiner in 2022.