My father, who flew combat missions for the Navy in Vietnam and then became a test pilot, told me after the loss of Columbia that if he had had a chance to make that flight and spend 7 days in Earth orbit, even knowing that he'd burn up on reentry, he'd have done it.

The Smithsonian article on John Young that you linked to is a good one. The only John Young quote they didn't include that I wish they had was his response to the proposal to make STS-1 an on purpose RTLS abort: "Let's not practice Russian roulette."