These kinds of drafts sometimes result in the players more or less proving everyone else was right for passing on them despite their hype or high rankings, that there was a reason they fell.
One draft class that comes to mind was the 2006 Eagles draft.
They got Winston Justice in the 2nd round and Max Jean-Gilles 4th round. Justice was supposed to be a 1st rounder and Jean-Gilles was a 2nd round type according to lots of people. Our fans on the board I was on back then were losing their minds with jealousy. With Jean-Gilles, it meant the Eagles would be a nasty run-blocking team for the next decade. And lucking into a left tackle like Justice in the 2nd round, it basically meant their QB would never ever be sacked again.
Not to mention everyone swearing 1st rounder Broderick Bunkley and 3rd rounder Chris Gocong would give them a fierce pass-rush.
And the board was littered with Big 12 fans (all the fans of various Texas and Oklahoma teams) saying how they'd all watched Colorado WR/PR Jeremy Bloom, and he would be a game-changing weapon.
Basically none of it came to pass.
Justice wasn't the player people thought when he was considered a 1st rounder. He started only 1 game in his first three years. Then he had a stint where he was a mediocre starter for a few years. He was out of the league before he turned 30.
Jean-Gilles was a sloppy mess who was also out of the league before he turned 30. He had a couple seasons where he was a starter, but he was mostly a backup type. His weight got out of hand, supposedly up into the 400's at one point. I heard he got lap-band surgery towards the end of his career, trying to solve the weight problem and salvage his prospects. Must not have made much difference. Frankly, those drastic weight-loss surgeries tend to mess with your body's ability to absorb nutrients when you do eat, so I wouldn't be surprised if that surgery ultimately made him weaker and hastened his exit from the league.
Bunkley and Gocong both started a good amount of games in the league, so I won't call them busts, but neither turned out to be productive pass-rushers. Both finished their careers with fewer than 10 total career sacks.
Jeremy Bloom was nothing but a practice squad guy, of course.