I think the best example of it done well was Helmut Zemo from Captain America: Civil War. He won because he exposed the flaws in the heroes.
Fundamentally, a story where the villain wins should be constructed as a tragedy rather than a comedy. If the villain is the antagonist, then he should...