According to the Bible, what happens when the Spirit of the Lord comes upon somebody?
Well, the short answer is this: a Spirit-possessed person usually kills things.
The phrase ("the Spirit of the Lord came upon him") occurs only 8 times (in 7 verses) in the Bible. Let's see what happens in each case.
Othniel
The Spirit of the Lord came upon Othniel and he went to war. (The same thing happened to Bush.)
And the Spirit of the LORD came upon him, and he judged Israel, and went out to war. Judges 3:10
Gideon
When the Spirit of the Lord came upon Gideon, he blew a trumpet. That sounds innocent enough (even if a little crazy). But Gideon (with God's Spirit) used the trumpet to summon soldiers to war. (For details about the war see Gideon's story: The Lord set every man's sword against his neighbor)
But the Spirit of the LORD came upon Gideon, and he blew a trumpet. Judges 6:34
Jephthah
When the spirit of the Lord came upon Jephthah, he killed his daughter as a burnt offering to pay God back for providing him with "a very great slaughter."
Then the Spirit of the LORD came upon Jephthah ... And Jephthah vowed a vow unto the LORD, and said, If thou shalt without fail deliver the children of Ammon into mine hands, Then it shall be, that whatsoever cometh forth of the doors of my house to meet me, when I return in peace from the children of Ammon, shall surely be the LORD's, and I will offer it up for a burnt offering. ... and the LORD delivered them into his hands. And he smote them ... And Jephthah came to Mizpeh unto his house, and, behold, his daughter came out to meet him with timbrels and with dances ... And she said unto him, My father, if thou hast opened thy mouth unto the LORD, do to me according to that which hath proceeded out of thy mouth. And ... her father ... did with her according to his vow which he had vowed. Judges 11:29-39
Samson
Samson had God's Spirit on him three times. Each time he kills something: first a lion, then 30 men, and finally 1000 men.
Behold, a young lion roared against him. And the Spirit of the LORD came mightily upon him, and he rent him as he would have rent a kid. Judges 14:5-6
And the Spirit of the LORD came upon him ... and slew thirty men. Judges 14:19
And the Spirit of the LORD came mightily upon him ... And he found a new jawbone of an ass ... and slew a thousand men therewith. Judges 15:14-15
Saul and David
The Spirit of God was on Saul until he refused to kill all the Amalekites as commaded by God in 1 Samuel 15:2-3. For refusing to commit genocide, God took away his Spirit from Saul, sicked "an evil spirit from the Lord" on him, and transfered his Spirit over to David, where it remained forever. (In a previous post I described some of the things a person can do when the Spirit of God comes on him.)
The Spirit of the LORD came upon David from that day forward. But the Spirit of the LORD departed from Saul, and an evil spirit from the LORD troubled him. 1 Samuel 16:13-14