Can't say L4d is the kind of game that this would work on me. Being that its less of a horror game and more a game of mow down the cannon fodder that causes adrenaline bursts.
The only times my hand sweat is when playing something that's slow paced, tedious, and has a high sense of danger. Like building dirt bridges over the void in minecraft.