Its funny how LJN has a lot of games with really good music. That song reminds me of another game that has my favorite SNES soundtrack, Vortex.
Anyway, on topic, I guess the 2 consoles I consider the worst I've played would be the original Game Boy and the Game Gear (I guess I'd consider handhelds to be consoles, whatever). The original gameboy has its place in history for sure, but the console itself now is just not that great. It's huge, so it doesn't fit in pockets very well, it hogs up 4 AA batteries like they are nothing and the screen is impossible to see, especially with sidescrollers or anything with scrolling. If I were to take a system for the purpose of playing gameboy games, I'd take my GBC over the original any day.
The gamegear is huge, it takes 6 AAs, the D-pad isn't very good, the screen is blurry like the gameboy's (except color, so kudos there), and there isn't any games on the system that I want to play. They also don't work too well anymore. I have 2 busted game gears sitting in my closet, I need to fix them sometime.