My favorite is Dan Harlan's "Hold it Buster" for a stand up show and Bannon's "Call of the Wild" for table hopping.
My last show, I got 4 rounds of applause while performing the Harlan effect. COW IMHO is the perfect hopping effect since it has a great story line and reset is automatic plus it is very visual.