This addon disables drone's screaming, pain and roar sounds in Alien Swarm.
Download
http://www.moddb.com/games/alien-swarm/addons/disable-drones-screaming
Installation
See FAQ, snd_updateaudiocache is required