You can get SNES Station from Zophar. You'll have to compile your roms disk yourself, but it's rather easy. The method for loading it is exactly the same as the one I outlined above for playing NES games on the PS2, only you use a PS2 Swap Magic disk in place of the Action Replay.
Unfortunately, the project hasn't made any progress in the last couple of years, if not longer. Most games don't play at anything close to full framerate. It's still worth checking out though, as long as your expectations aren't too high.