Heh, I've done that too. ... several times.
> The good news is that the carts seem to handle this well. The SNES
>on the other hand is not so forgiving.
Really, I've had the exact opposite happen.
The SNES is always ok. The cart (if it has battery backed ram) ... something fries in on the SRAM battery backup part (never cared enough to figure out what exactly fried). So the game still works ... but I can't save data.
If the cart doesn't have a battery, one of the chips gets fried. Someone sent me a TopGear3000 they did this too ... it looks like they fried the security chip, the address decoder, the rom, AND the DSP. What the heck! Usually only one thing fries. I think there's something he 'forgot to mention' ;)
But, if you notice real quick ... everything is ok. Chips have quite a bit of internal protection.
------------------------------
anyway, TheDumper's right ... go for the power supply.