I hope it's ok to revive an old thread?
How about the bouncing bomb, used famously in the "Dam Busters" raid. Although regarded as a local tactical success; the failure to achieve its wider strategic goals and high collateral damage cast a shadow over its overall effectiveness.
http://www.bombercommandmuseum.ca/s,dambustersstudy.html