I don't find his cover up story at all credible - Pakistan knew where Bin Laden was the whole time and kept it a secret from the U.S.? For what possible gain?
In many ways, Pakistan is like Saudi Arabia or Turkey: countries the US cannot afford not to be allies, but with very different strategic interests, often conflicting with US ones. I don't find at all strange that they might have harbored Osama all along, just as another bit of leverage in the eternal game of foreign policy.
That is, no possible gain that a rational person would understand. But Islam is not a rational memeplex.