This song reflects the words of this psalm. We used to sing this in Moscow when we had a jazz pianist as our accompanist. You never were sure where it would end up, but the words never changed. Better is one day in our courts than a thousand elsewhere.
In encourage you to listen to this song and follow along in the psalm and I think it will speak to you.