Tell me, when Adam and Eve did the foreordained action of eating the apple did they act like robots? No. They acted out of their own free will but, it also was an act foreordained by God.
To say that a human act of sin was foreknown, allowed, and used by God in some manner is different from saying that God
foreordained it. When God commanded Adam not to eat of the fruit did He
want, and even cause, him to eat of it? Are we expected to stretch and read between the lines to such an extent as
that? Do we even
need to? Or are we not better off simply understanding God's will in the sense that the overall preponderance of Scriptural verses from Genesis thru Revelation state it, IMO, which is that humans are simply obligated turn to God in faith and trust and love and remain in a relationship based on those things and then strive and persevere and endure and overcome, etc, while recognizing that grace is absolutely essential in moving us towards Him to begin with and helping us remain there. Anything else is really more than we can-and need to-know.
As I see it, Gods sovereignty is not compromised by the fact that moral evil (sin), resulting from the abuse of free will by created beings, is allowed for a
time only, and utilized for His purposes. And that concept isolates Him from being the direct cause, by directly willing, every one of the most horrific evils that humans have experienced as a result of deliberate and malicious acts by other humans, not to mention all the lesser such evils we experience daily.
In that case man is truly blameworthy for sin; he's a morally accountable being (as we all know is true intuitively). And God can then, in line with His truth and justice, rightfully
hold man accountable.
And this explains why God has been working with humanity down thru centuries of life in a world effectively exiled from Him but where, little by little, with the addition of revelation and grace, He's paved the way for the full light to be shown in the person of His Son because by then we might be ready, just ready, to begin to embrace that light. It's always
been about the human will, imperfect, weak, limited, and compromised as it may be, about God patiently drawing that will into alignment with His own perfect will so that justice finally prevails in His creation, in beings who've learned the hard way of their need for that, for Him, if they
will. Adam had thought otherwise-and has presumably learned
his lesson by now. And this explains why this world is even necessary: it's a school, a training ground, for the human will. Otherwisese it doesn't really have much purpose; God may as well have just stocked heaven with the elect and hell with the reprobate to begin with if that's His ultimate will anyway.