The Amiga CD32 - wasn't the console's fault that Commodore went bust due to some copyright issues, the console only sold a few hundred thousand units I believe and was only sold for about 8 months; so the company behind it was the reason the console failed.

I just got delivered a CD32 and masses of games for it - the CD drive is painfully slow, but the games are very good!!

How about this one - Amstrad GX4000. I have one of these too. System failed as only had a small number of game carts (about 52 I think it was in total) and the large majority of those were charged £25 for a game cart with exactly the same game as their cassette version that cost £3.99. That is why it failed. Many GX4000 consoles were given away as "bum prizes" in gaming console magazines. Actually, it has about half a dozen excellent titles.