How to Make People Fall in Love With Your Ridiculously Competent Hero

We all love characters who are good at what they're doing. Nobody wants to root for someone who screws up constantly or walks into traps we can see a mile away. But at the same time, it can be hard to love someone who's too perfect. So how do you make us believe in, and love, a major badass?