What I'm saying is that His foreknowledge of a future event is in some respect appreciably different than the actual experience of the event. What I'm asking is, If His experience is not appreciably different than his foreknowledge then what his purpose of experiencing actual events?
Just because you know that getting a broken leg will hurt, will not stop you from getting a broken leg.
God knew that by creating us, we would eventually turn against Him because of the lies of Satan. So, what God did was have a plan/system already built-into creation itself for redemption. Else why were there prophecies of Jesus in the OT? God didn't stop us from getting a broken leg, He just warned us that it was going to hurt, but that there is time for healing afterwards. Not accepting this means we would never heal, and die in our sin.
Which begs the question, why did God create us in the first place, knowing we would be evil and that some of us would spiritually die? Why wouldn't an all-knowing God be able to make things perfect for all time? How would we know how awesome heaven is, if we first didn't live in this fallen world we now live in? If we never knew sacrifice and strife, how would we know if heaven was really where we wanted to be?
Big questions, but I think they can be answered.
"If" God is all-knowing, then He knows every possible alternate reality that could ever exist which would cascade from His very thoughts and actions. So, considering this, He likely created everything in a manner that would lead to certain un-avoidable events.
But, if free will exists (as I believe it to be so), then how is this possible? Simply put, our free will does not negate God's soverign will.
We can, along this "stretch" of time that we currently occupy, do what we want. Regardless of this, God will cause certain things to happen, even using those who go against Him, to complete His vision of time. In the process we either accept God and his version of reality; or die in our sin by accepting our own version of reality, while at the same time serving Satan in our rebellion towards God.
In the end, both/all realities serve God's purpose, and free will is not negated.