Two-time Pentagon chief had a storied career in government under four presidents, but his vision of a modern US military was unraveled by the long and costly war in the Middle East