Also we can't forget his stint as "Golga" from the Oddities w/ his "Cartman" obsession.
That's the moment. Earthquake was "deathly afraid" of snakes and the ref made Jake the Snake put his pet in a sack and hide it under the ring. Later, Earthquake had tied up Jake the Snake in the ropes and proceeded get the sack from under the ring and sat on it to smoosh Lucifer. A few days later Jake produced Lucifer's twin brother, Damien (who looked suspiciously exactly like Lucifer). At the time, though, I was deeply saddened.
Earthquake's entrance theme (just the sound of an earthquake) was also pretty cool.
Don't forget his appearance in the Wrestlemania (I think it was either 18 or 20) Gimmick battle royal.