3DO: Cost $800 when it came out and was full of incredibly lame kiddie multimedia games like Shelley DuVall's It's A Bird's Life and Putt Putt Goes To The Moon and everyone really hated Trip Hawkins (Panasonic CEO) because of it. I think its main legacy as a console is that it's the only place outside of an arcade back then that you could get Super Street Fighter II Turbo.
Atari Jaguar: It wasn't really a 64 bit system!
Virtual Boy: Retailed for $25 at Wal-Mart within months of its release. I never knew it was like the game equivalent of New Coke though.
I also remember loads and loads of sneering at the idea of Sony and Microsoft making game consoles, before they actually did it. "Sony Play Station" got lots of laughs because of its name alone.