If McCain was your pilot, would you be comfortable flying with him?
He lost five Navy aircraft in his career. That doesn't make you a hero. It makes you dangerous. And the reason he wasn't grounded and stripped of his wings is because his dad covered his ass repeatedly. Any other Navy pilot would've been dumped after the second crash.
That said. I believe McCain is a hero for his leadership in the POW camps, and POWs I've heard speak about their experiences there (in SERE school) have referenced his example. He stayed tough in captivitiy and inspired others to remain tough.
However, he didn't win any war, nor has he ever even planned and executed a military operation at the operational, theater, or strategic level.