Why would God bother to place us here? Didn't he see it coming?

Hi, hello. I have been wondering lately if God knew what he was doing when he chose to place us humans on a floating speck in a black void and give us authority over it. God knows everything that we are going to do in our lives, every sin we commit, everything that he will be pleased with. He knows those who will follow him and all of those who won't. If he knew that Eve would eat the fruit then why would he even have bothered to create humans? Why didn't he just foreshadow what we would do and say "Oh, wait, maybe I shouldn't give them authority over their own place." Things just don't make sense to me. I fully believe God is our ultimate creator and that he loves us dearly but I don't understand why we were created this way. Wouldn't it have saved him the heartache if we weren't here? Life is so puzzling. I am exactly like my grandfather. I question everything. I feel as though my soul is searching for something. Something deeper.