Bush was a pretty big bust because his hype was off the charts. No one believed the Texans would pass on him at 1.01, and they took a lot of crap for picking Mario Williams instead. Bush had a decent career as a role player, but never made a Pro Bowl; at 1.02 that's a whiff. Williams wasn't exactly a major star, either, but clearly Houston got more out of him than New Orleans got out of Reggie Bush.
Worth noting: That was an amazingly crappy draft. The biggest hits were Williams, Jay Cutler, Haloti Ngata, and Antonio Cromartie. Maybe Deangelo Williams or Maurice Jones-Drew if you want to count them.