In heaven we will be totally fulfilled since we will see God as he is which is called the beatific vision.
“The beatific vision, in which God opens himself in an inexhaustible way to the elect, will be the ever-flowing well-spring of happiness, peace, and mutual communion.” (CCC 1045)
“Now we see but a poor reflection as in a mirror; then we shall see face to face. Now I know in part; then I shall know fully, even as I am fully known.” (1 Cor 13:12)
Our understanding of God is limited on earth. What we see is ‘dim’ compared to the reality. It is called a reflection since we don’t see God face to face, but get to know him through his effects, what is in Scripture, in the lives of the saints, etc, and even in our own life and our hearts. All that we truly yearn for will be satisfied in heaven when we see God face to face which is called the beatific vision.
We yearn for intimacy in this life. In heaven we will be fully filled with God’s goodness and love. It is more than we could ever ask for or imagine.
This ‘vision’ is not just that we will look at God, but will be transformative of ourselves. It will fill us in such a way, we won’t want anything else. All the good things of this earth come from God. We will get to see and experience that infinite goodness itself.
But what is so good about heaven? What makes heaven so good is God's infinite love. God shares all of Himself with us, not just part of himself. All of God’s infinite goodness, truth and love is ours in heaven. There is no end to all of that giving of God. God is the source of all the goodness that you desire. Think of anything good that you desire and realise that that goodness comes from God and he has an infinite amount of it that he wants to share with you. Let’s take one analogy. Imagine your favourite food. In your first day in heaven God gives you that food. Then the next day he gives you something better. Since God is infinite he can keep on giving you a better food every day for infinity. Heaven is never boring. Remember this is just an analogy and the reality of heaven is infinitely better than this.