Why would God create humans if He foresaw that most of them would go to hell?

As Catholics we do believe the majority of people go to hell, and we have examples like the first six chapters of Genesis, where out of millions only eight are saved, and Romans 11, where out of millions in Israel only seven thousand had not bowed the knee to the devil. God is not concerned about numbers; He wants faithful people. Now, even though God knows this will happen, we have to see that there is only one future, not several, so God's knowing it does not change it. The right place to ask the question is not after creation, but at the point where God decides whether to create at all, and here we have to compartmentalize eternity into time slots just to speak of it. What made God create rather than not create, knowing the future? We probably do not really know. God is perfect and needs nothing, yet here we should question our metaphysics a little, because Scripture speaks of God being joyful and pleased in a real sense. Things can be added to God that He does not need but that still give Him more pleasure, love, and virtue, because He recognizes them in a being outside Himself. So when God decides to create, He includes the fact that the second Person of the Trinity will make it possible for even a small number to be joined to Him forever, and that the rest will not care. But the creatures cannot be robots; for love to be real it must be freely chosen, and that requires free will. What pushed God over the edge to create, knowing all the suffering, was the love He anticipated from His creatures. We will not know the full answer until we meet God.