I watched pretty regularly from 1991-2000, and then caught wrestlemania from around 2008-2012 and one or two since.
There were a few top guys who I just didn't think were that good, though, Sid although he had an awesome look, you just knew he wasn't going to win any feuds, so he didn't matter that much.
Shawn Michaels up to wrestlemania 14 seemed like an imposter to me. I didn't buy him as the champ. When I watched the later wrestlemanias he was great though.
HHH, I actively hated his over-pushed blue blood character, which was good. Having the Ultimate Warrior crush him was satisfying, he was so detestable. But, when he became just another guy but kept winning all the time, he became boring. He stuck around too long too, keeping in the main event scene long after the guys who elevated him with real charisma moved on.
Y2J was overhyped and not a quality successor to Rock/Austin. I liked him in WCW with Ralphus, man of 1004 holds, etc, but his WWF character couldn't carry the weight.
Jeff Jarrett, when it became clear WCW was going to push him to the top, the show wasn't worth watching. "Slap Nuts" didn't make a whole lot of sense. Double J wasn't bad, he was easy to hate when the stakes were low, but not the guy you elevate to star status.
Lex Luger, couldn't quite commit to a character, and his finisher was terrible. If he used to huge clothesline or forearm smash after they played up his steel reinforced arm as an established finisher, maybe he could have believably gone over some decent opponents, but the torture rack was garbage. He was constantly between villain/hero and worked best as second fiddle.
On Ultimate Warrior, he was awesome when I was a kid. He was a living breathing superhero and his insane promos didn't stand out so bad when you had other strong, heavily coked up, characters taking into the camera every show. When he burned out in a few months in 96 it was clear that he was not worth caring about any more. By the time he did that weird program in WCW he was just a nostalgia figure. So, up to 92, awesome, I was 6 years old, as a more discerning 10-13 year old, his work didn't hold up.