Super Empire Strikes Back was pretty cool. My collection of SNES games is pretty weak, and that was my favorite game. Knight of the Round Table is a good arcade beat-em up, with two player co-op, which is pretty fun. Probably my favorite type of game, the best example being Aliens vs Predator in the arcade. That sucked up a lot of quarters.
If you get nostalgic for the SNES, you could buy a USB adapter, and play games on your computer with the SNES controller. Lots of fun. I purchased one from:
RetroZone