This is a plugin for System Preferences that lets you detail what each button does, and ensure that it only applies to particular applications.
However, I'm sure it's pretty much identical to other brands of NES/SNES USB controllers out there. I found a solution! For the record (and for Google search results' sake), I'm using the GTron (G-Tron) USB SNES controller or gamepad.
