I loved when DDP was a midcarder in WCW. Even during his time with having Maxx Muscle as a bodyguard and all that. Classic stuff. He had some superb matches in WCW, even with job guys. Really great talent. I liked him in WWE too, but they could've done so much more with him; though him smiling into the camera every week at random times was keeping him on TV, so I can't complain.
Dean Malenko and Marty Jannetty are two others.
The Stud Stable, with Colonel Robert Parker in WCW. Geez, everyone was in there at some point. Dick Slater, Bunkhouse Buck, Arn Anderson, Steve Austin, Mike Enos, etc. All great talents in their own respective ways.
Another guy I liked a lot was Johnny B. Badd / Marc Mero.
Tag Team Wrestling