Still seems to me that people aren't getting the thread. Diesel, HHH, Goldberg, DDP, Warrior, Foley were all over with the crowd, their wrestling abilities are not on trial here.
Here is my list(in no order)
Mable
If you watch the KOTR PPV he actually is over, but I really think where he fell off was when they had him in the Main Event of Summerslam against Diesel. The fans wanted Diesel to face a monster, but I believe they wanted someone like Taker and not a large fat guy who used to rap. I almost don't blame Mable for this, more so the landscape of the company at the time.
Dude Love
Now I for one like the Dude Love character, but the fans were not so happy with it at the time. Steve Austin had just won the title months before at Wrestlemania 14. Dude Love was Cactus Jack at the time and was tagging with Chainsaw Charlie(aka Terry Funk). Foley retired the Cactus Jack character on an episode of Raw and turned Heel becoming a corperate tool for Vince. This is where fans started caring more for Vince vs SCSA than Dude vs SCSA. Perfect examples are looking at the famous Raw match with Vince vs SCSA, where Austin had one hand behind his back. Dude's interference did draw a reaction but fans seemed to care more about Austin vs McMahon. I will even go as far as to say McMahon should have used Goldust in this place, who had a world title match against Austin on Raw and cut a fantastic promo that got a lot of heel heat. Personally though, I loved the Dude vs Austin feud, I just think the fans wanted a more high profile feud for Austin's first feud as champ.
Farooq
When the Rock took over The Nation of Domination in 1997/1998 he feuded with 3 superstars before the famous DX feud. Ken Shamrock, Steve Blackman, and the Ex-leader of The Nation Farooq. Shamrock had been over since the Title match with Bret Hart early in 97 and Blackman was a newcomer who was getting over(both should have feuded with Austin eventually, but it never happened) When The Rock faced Farooq at Over The Edge in 1998 Farooq got no response what so ever. The fans at the time really loved to hate the Rock but this didnt help Farooq get over. Farooq would then go on to flounder in a tag team with Scorpio(who was very over) until he found his calling with the APA. On a side note, its funny that he is more known for the catchphrase DAMN! than being NWA champ.