We're all looking for paradise. We want to live in a garden of God's favor and delight. We yearn for his true grace and goodness. We yearn for God himself to be present. This psalm points us to God. And 1500 years later God would speak through the Apostle John with this promise:
And I heard a loud voice from the throne saying, “Behold, the dwelling place of God is with man. He will dwell with them, and they will be his people, and God himself will be with them as their God. 4 He will wipe away every tear from their eyes, and death shall be no more, neither shall there be mourning, nor crying, nor pain anymore, for the former things have passed away.” - Revelation 21:3-4
This is our truest need and God's gracious blessing.