Can't believe Larry Zbyszko and Williams & Gordy were mentioned.
Larry was fun in The Enforcers, The Dangerous Alliance, and during his feud as a babyface against Regal. That match had me cheering Larry and booing Regal, even though I wasn't a Larry fan and always liked Regal.
I've only seen the Williams & Gordy team in WCW, but I found them awesome to watch...very intense, in a way we rarely saw from that era (in America).
Even the Triple H suggestion is a bit mind-boggling, though I can understand the sentiment, because he has been shoved down everyone's throats.
I almost suggested Sting and Lex Luger. Against the right opponent, yes, they shined. But in normal, every day situations, I found them bland, bland, bland. Of all the things Sting especially is overrated for, charisma and personality top the list. Having spiky hair and facepaint does not equal personality. But to be fair, while they weren't as good as their spots, they were just good enough. So, I can't honestly suggest them.
Maybe Marcus Alexander "Buff" Bagwell? Decent heel personality near the end, but I can't think of one truly great match he's had.
Even then, I don't know... "Buff" was still a fun midcard gimmick. The problem is, no major league wrestler is boring in every aspect. They all have at least one thing going for them, even if that one thing is overshadowed by a million other deficits.