Why did the Spirit lead him to be tempted by the Devil? What about Job? How did God not set Adam up to be tempted? Why does Jesus tell us to ask God not to lead us into temptation if it is nonsense?
Sorry if I didn't explain these things clear enough, but let me try in a simpler and more systematic way:
Let's start with the fact that God is good, holy and righteous. God is not the source of sin. He does not create, bestow or impute moral evil, but He does punish evil, which is perfectly in line with His good, holy and righteous character. That is, to punish evil is in and of itself a good thing.
Then let's consider Jesus Christ, who is the Saviour of the world. God is the one who, from beginning to end, saves us. He unites us to Himself and He does not lead us astray. He is the Good Shepherd.
Now, with these things in mind, we can read specifically what Scriptures say of God's testing and of satan's temptation and our own sinful flesh:
Parable of the Sower - Notice who it is who is leading us away from God's Word: It's satan and our own flesh. Not God. Luke 8
The evil works of the flesh - These things come from our own flesh. Not God. Galatians 5
God is the one who guards us against temptation. 1 Corinthians 10:12-13, Mark 14:38
"Blessed is the man who endures a trial patiently, because when he has stood the test, he will receive the crown of life, which God promised to those who love him. Let no one say when he is tempted, “I am being tempted by God,” because God cannot be tempted by evil, and he himself tempts no one. But each person is tempted when he is dragged away and enticed by his own desire. Then when desire has conceived, it gives birth to sin. And sin, when it is full grown, gives birth to death."
James 1
So, we can understand that God (besides punishing evil, and handing people over to evil as a punishment of their sin) does indeed test, but not tempt. There's an important difference between testing, tempting, and punishing. And again, we shouldn't confuse the temptation of Christ (which serves to prove that though He is fully man He cannot be tempted, which testify to that He is God, and that it fulfils all righteousness in our place), and our own sinful flesh and the devil tempting us, with the act of God testing us, which is for good.
In short, when we pray "lead us not into temptation, but deliver us from evil" we pray that God, in His great mercy, may keep us steadfast in faith. It is not a revelation that God tempts people to sin, and it has never been understood this way in the Church, though it has caused some controversy.
There's much more I can say about this, and I also think it's important to understand that the temptation of Jesus, and of Job, and of Adam are all very unique and serve to reveal different things. Jesus, being the Saviour, God in flesh; Job, being saved by God; Adam, although righteous before God, falling into sin and losing his righteousness before God.
Suffice to say, temptation comes from our own sinful flesh and satan, not from God, and God does not lead us to sin.