At Citizens Bank Park (Philadelphia Phillies), a lighted Liberty Bell rings and moves back and forth. The Red Sox farm team - the Portland Sea Dogs (Portland, Maine) - have a lighthouse that pops up and sounds a foghorn whenever a Sea Dog hits a homer. Some interesting traditions...
You're killing me Ensberg
At SBC Park, the Giants shoot off some sort of steam from three stacks by the right field arcade (overlooking McCovey Cove), and a foghorn goes off. Also, a cable car bell is rung. That's really cool. And we cheer. :-)