I spent some time looking around, there are remixes from a whole bunch of games, some of which I've never heard of. One game I remember playing on SNES is Donkey Kong Country. I always liked the music from the final showdown with the big boss, although I'm not really into dance music.
Here's a remix of that, but with metal guitars added in, and with heavy drums that have thundering double-bass. I'm a metal drummer, and so this is the kind of drumming I like. The "dance" style melody has been changed a bit so it almost sounds like synth guitars. They have an Iron Maiden sound to them. Anyway, I really liked it. http://www.ocremix.org/detailmix.php?mixid=OCR01272