X Files has a great light and sound show when you get the Super.
A couple of others already mentioned that came to my mind as well...
Gimli's great Whoa-oa-oa, SUPER JACKPOT!
BK2K, superb celebratory music that just keeps carrying on.
Sopranos Stugots Super is a great celebration too.
Not technically a jackpot, but I never get tired of hearing the bell on BK get set off either.