A worse day for Balaam

In Numbers 24 we see Balaam going home. In Numbers 25 we see Moab seducing Israel. At the end of Numbers 24, I thought Balaam's story was done! Evidently not- in Numbers 31 they kill Balaam and then when they come back from the battle Moses asks them:

15 "Have you allowed all the women to live?" he asked them. 16 "They were the ones who followed Balaam's advice and were the means of turning the Israelites away from the LORD in what happened at Peor, so that a plague struck the LORD's people.

then in Revelation 2 it refers to more of Balaam's legacy:

14Nevertheless, I have a few things against you: You have people there who hold to the teaching of Balaam, who taught Balak to entice the Israelites to sin by eating food sacrificed to idols and by committing sexual immorality.

So, he seems to have been behind a lot of troubling things, even though most of Num. 22-24 focuses on how he cannot curse Israel, which seems to have been a positive thing. But was this showing that Balaam really wanted to curse Israel and God had to do a strong job of holding him back or was he just one of those laid back guys who goes with whatever the flow is for the moment?