Total flops usually don’t get to keep and use their jewels.
One who comes to mind whose offspring generally outperformed himself is Pioneering, a half brother to Storm Cat. He was unplaced in listed stakes and only had a maiden and allowance win in 6 starts. While he didn’t light the world on fire, he did sire quite a few graded stakes winners much better than himself before being sold to South America.