"required capability" Surely that phrase cuts to the heart of the problem as half the time it's not clear exactly what it is...so a super gold-plated spec is written which sends the cost and timescale into orbit.
My vote for the success story would have been the Buccaneer. And that only worked so well because Blackburn were able to convince the Navy (with extreme difficulty) to remove supersonic capability as an essential requirement.