To get a drunken effect you could try spawning an invisible explosion. I believe some weapons do this to simulate recoil as well. Looking at the rocket launcher, the following fields set in an explosion datablock will adjust the strength of the camera shake.
shakeCamera = true;
camShakeFreq = "10.0 11.0 10.0";
camShakeAmp = "3.0 10.0 3.0";
camShakeDuration = 0.5;
camShakeRadius = 20.0;
Be sure to set the camShakeRadius to a value that will only reach a player if it's spawned directly at their position.