The scriptures give us numerous examples specifically telling us things that God wanted that didn’t come to be and will NEVER happen. You said you agree that man has disappointed God since creation, God didn’t want that. God didn’t want to kill everyone in the flood, it was an unfortunate part of His plan. The scriptures say that He grieved in His heart because of the wickedness of man. Now if you don’t think that’s not an example of God wanting something and not getting it then this discussion is pointless. Yes He knew it would happen, yes He knew He was going to do it but obviously it was not something He delighted in or wanted to do. According to the scriptures it appears that it was something that He had to do for the greater good.
By the way, it might be worth mentioning that this could be taken to mean I said something I didn't. In this case, I don't think you meant to do that, but that say that, as I agreed that man has disappointed God since creation, therefore I should see that God didn't want that. But the way it was written, I don't want anyone to think I agree, simply with the idea that "God didn't want that", period. After all, God fully intended that Christ should suffer and die, yet Christ agonizingly pleaded not to have to go through with it. (As an aside, yet relevant, he mentioned "if there is any other way", well knowing there wasn't; he obviously "didn't want" it to happen, in that sense, but it had to happen, to obtain the end God had predestined from the beginning, which is also what Christ "wanted" and what the Father "wanted" also.
Would it suit you better that the question "does God want all to be saved" was answered, "well, yes and no."? Or better, that the question, "does God want many to perish", was answered, "well, no, and yes".
God obviously wants obedience from willed creatures, but he himself created them, and put into play the emerging of the very thing that causes disobedience, just as he willed to happen.
What's interesting to me is that a purely etymological use of "want", concerning God, is mutually exclusive with "will". That may show up in a valid study of the Doctrine of God and his attributes.