In today's second reading from the Liturgy of the Hours, we read this discourse from Pope Pius X. He speaks of the joy of the Psalms and their sorrows as well. I particularly like Psalm 51 as it teaches us to cry out for the mercy of our beloved God. Blessings!
From the apostolic constitution Divino afflatu of Pope Saint Pius X
Indeed, who could fail to be moved by those many passages in the psalms which set forth so profoundly the infinite majesty of God, his omnipotence, his justice and goodness and clemency, too deep for words, and all the other infinite qualities of his that deserve our praise? Who could fail to be roused to the same emotions by the prayers of thanksgiving to God for blessings received, by the petitions, so humble and confident, for blessings still awaited, by the cries of a soul in sorrow for sin committed? Who would not be fired with love as he looks on the likeness of Christ, the redeemer, here so lovingly foretold? His was the voice Augustine heard in every psalm, the voice of praise, of suffering, of joyful expectation, of present distress.