In my humble opinion I think you are forgetting about free will. God in His Foreknowledge, knows how we are going to act from the moment of our conception.
But then we have a Frankenstein situation with God and man in which the creature determines the creator's actions. To paraphrase St. Augustine, God grants one efficacious grace not because he foresaw that they would eventually co-operate and be good, but in order that they may be so.
Welcome to the board here DecemRationis, I always think on that one verse in the Bible you quoted: "I will have mercy on whom I will have mercy,"
I think that's a point a lot of people miss. Everyone at some point has either the guilt of original and/or actual mortal sin on their soul. God is at perfect liberty to either pardon them, grant them efficacious grace, and regenerate their wills, or to leave them in their current state. When God does do this it was not because of one's will, but God's mercy. Also God's mercy does not just mean a pardoning and forgiveness of sin, but also an aid in preventing from falling into future or further sin.
Liguori had an in-between view, I forget the name of it, but that is what I have.
Sorbonne Congruism, and St. Alphonsus rejected the scientia media
view of other Congruists and Molinists. My own position currently is probably between this one and the Thomist view, yet closer I believe to Banez and the Thomists.
I think Molinism has been like a cancer in The Church, expanding and undermining even the most fundamental of doctrines (Original Sin, EENS, etc).
I agree. It sounds way too close to deism and tends to play out in that way ("I did good work x, God owes me"). Four centuries later and even many if not most Conservative Neo-Catholics and some who call themselves Traditionalists believe that man is basically good, that numerous amounts of pagans will be saved because they followed their pagan "God(s)" as best as they could, etc.
It does not surprise me then that many of the Americanists a century ago had Molinistic views of grace. This view may be unpopular, but I think Molinism has created many false converts/reverts, as well as keeping many people physically/external in the Church, especially this side of the Atlantic who shouldn't be there. There seems to be a tendency amongst those who adhere to Molinism to water-down hard-sayings in order to try and get people to convert or to stay in the Church when they don't really believe, in essence making co-operation easier for them (i.e manipulating grace and playing with souls).