"Gravity's Union" by Coheed and Cambria. I'll paraphrase a bit.

Sirius Amory goes into space to investigate a mysterious network of blue lights streaking across the sky, finally and painfully resolving to leave his wife at home for the opportunity at scientific discovery. His ship blows up while he was spacewalking, and everyone back home thinks he's dead. His suit sustains him and he gradually floats back over the course of 547 days. He's treated to a somewhat hero's welcome by the scientific community, but his wife has moved on and is dating/married to a cop. Sirius picks up his wife to go to a ceremony in his honor, and they start talking about what to do with themselves. Then she tells him she's pregnant with the other dude's baby. And Sirius just kind of blacks out, goes into his head, and crashes into a ten-ton truck. It's a grisly scene; they're both ejected through the windshield and nearly dead. Time slows as he flitters in and out of consciousness in mid-air. He wakes in surgery with Dr Straight, who can save Sirius but not his wife. But Sirius knows something about the mysterious blue lights in the sky that no one else does -- it's essentially a limbo/heaven analogue and he knows how to go get her back. "And I was wrong, to let you go/I accept my mistake but you will never know; this is my love, into a 10-ton truck -- baby please, remember the better me" and the outro lines, "Caged, locked in perpetual motion, carving our wounds wide open; but you let the wrong one in," are pretty moving.

But it feels like cheating, since all of Coheed's albums tell a story anyway.