Did God Know Adam and Eve Would Eat the Apple?

I was thinking of this the other day in church.  If God is omniscient (all-knowing), then He must have known Adam and Eve would be beguiled by the Devil.  Yet, He asks in Genesis, “Hey Adam, where are you?  Who told you you were naked? Have you eaten from the tree that I commanded you not to eat from?” (Genesis 3: 9,11)

This must be a rhetorical question.  God knew what had happened.  God know what would happen.

So why create all this in the first place?  Why would God create man, know we would fail Him, God suffer heartache because of it, God have to send His son to redeem us (more heartache for God), all so we piddly humans could be with Him?

Why bother?  Why would God even bother to do all of this?  It seems like a lot of work on His part and I’m not sure His reward. Us?  From my perspective, we don’t seem worth it.

Logically, it’s because of God’s immense love for us.  But I can’t comprehend this.  I can’t comprehend God’s love because I believe God loves differently than we love.  We are motivated by fear, insecurity, and every other human emotion and circumstance.  God isn’t.  God’s love is pure.

This is definitely going on my “ASK GOD” list when I get to Heaven.  I’ve noticed a lot of these lately are “Why” questions.