I agree with "hey jude" & "velcro fly" woven into the story, and they should be in the movie, but.. ..not as a theme song.
I still think "Hurt" would have the most impact.
Roland's quest at all cost. Think of his long long painful journey, just imagine sound bits inserted here and there, but the final realization at the end. Can't say anymore.