It would have been cool if someone had made a NES and/or SNES cartridge which had a built in CD reader.
https://en.wikipedia.org/wiki/Super_NES_CD-ROM
Part of the issue with these sorts of console add ons is that they just split the addressable market further. ISV's either have to address only console owners with the add on, or they can address everybody with the console if they can manage without the extra hardware. Commercially, this can be a hard sell, which makes it difficult to sell the add on, making it even more difficult to write software requiring the add on.
No add-on has been able to survive more than one year outside Japan. Not even PS VR, whose sales are too low.
https://www.engadget.com/2011-03-09-microsoft-sells-10-milli...
From 2011. At any rate, it obviously satisfies the grandparent’s comment on success. (Also, you may be thinking of the Xbox One, which they received flak for bundling with a Kinect)
Certainly 10m standalone units warrants the ‘success’ tag, I’d imagine — thanks for the link.
I also had some turn based Dracula adventure game where you chose how to spend your time that was terrifying to me so I once hit the “rest” button in my Victorian era London apartment until it was 1994, which I thought was pretty hilarious ( Dracula would just immediately kill you when you ventured outside but 10 year old me didn’t quite realize how video games worked).
The PS1 didn’t really have those weird experimental FMV games but wow demo disks were my bread and butter for a poor kid.
Sega 32X worked at least, sadly it wasn't very popular either.