My favorite might be the second song in the final part of Messiah, where we are reminded of the reality and grief of physical death. It's called "Since by man came death". There is a very dark, somber, first phrase sung to communicate the despair of our inevitable date with physical death because of Adam's sin and our inheritance of his curse. Then, in sharp contrast, there is a bright, victorious declaration of the final resurrection that will occur for all those in Christ.
Here are the words, listen to the song as you read (the first part is very soft, so listen carefully):
Since by man came death, by man came also the resurrection of the dead. For as in Adam all die, even so in Christ shall all be made alive. (1 Corinthians 15:21-22)
Losing my father six months ago continues to sting. The thought of a loved one dying-even one who was a Christian and now with Christ- brings continued sadness. This song really captures how I feel (dare I say!). It is somber and depressing when declaring the reality of death because of sin. Death is because of sin, it's an aberration. The thought of my father's death will always bring a sense of pain. However, the truth of Scripture witnessing to the fact of Christ's resurrection means this pain will not last forever. It will not even last long (relatively). There will be a final resurrection for all. Those who are "in Christ" will be joyously and gloriously reunited with each other to bring praise to God.
This short song captures the truth of Scripture and has served to comfort me.