He kind of sucked, right? Outshadowed in every partnership he's been (E&C, Edge/Rey, Edge/Lita, Rated RKO, Edge/Vickie, Edge/Jericho), inability to be good outside of gimmick matches, frequently injured, consistently overpushed his entire career, basically killed Smackdown for a decade after his terrible terrible La Familia run, promos ranged from horrible comedy (watch the 2000/2001 era stuff, it's absolutely brutal, pun intended) to overwrought crazy/serious which meant he'd pull his hair and shake.
He's been pushed SO hard as a top level WWE legend since he retired since anyone who retires or dies prematurely gets martyred. In the end, he's about the most groan worthy guy if I even end up watching 2003-2011 stuff. He has maybe 4-5 matches in his main event run worth talking about, and only one of them isn't a gimmick match (Taker vs Edge at WM, which in retrospect was the turning point in the streak becoming finisher fests and making it impossible to buy one tombstone as a finish).
He's almost Jeff Jarrett-esque, in that he's a competent enough guy who kept inexplicably being pushed to the top of the card even when it was a detriment to the show. WWE willingingly killed SD to keep pushing him, giving him the blue version of HHH's death reign, except even worse.