What happens after you collect all the Intel in MW2?

Nothing, but there is at least 1, 2, or 3 enemy Intel items on each campaign mission, 22 Enemy Intel items gets you an achievement that is worth 25 Gamerscore and if you get them all (For Xbox it's 45 items), you get an achievement that is 40 Gamerscore.