I'm surprised no one has said Rumble Roses, Dead or Alive Xtreme or something like that. As for me, Glover on the N64 falls under that category.
EDIT: I can't believe I forgot the mention Space Station Silicon Valley before. It wasn't universally considered a bad game or anything, just no one bought it, or heard of it. It was an obscure N64 game where you were a robot microchip that could take over the bodies of robotic animals in this space station. It had many levels to it, with varying environments, and it was an absolute blast to play. I really hope to see it on Virtual Console some day. There was also an infamous glitch in it. To get to the real end of the game, you had to collect these items throughout the levels called souveniers, well there was one particular souvenier that couldn't be collected. If you tried, you went right through it! The only way to actually finish it was by using a GameShark, or device of the like.