I remember those. They were advertised in issues of EGM as well as others. I think it was called the
Video Jukebox VJ (I remember the advertisement
without the carts in the guys head. I also recall a version promised for the SNES and I've heard rumors of one for the NES and SMS (doubtful). My friends and I dreamed of one for the N64 as well.
There used to be a bay area shop that advertised them asking over $100 a pop for the beasts, yet according to forum posts, these things were never made it to retail. It's possible, I've seen the kiosk units but never the Jukebox VJ. If they existed, it would have shown on eBay at least once by now. But I digress, a $100 accessory for a console that probably cost $150 new (or whatever they cost at the time) that was at its peak and obviously on its way out.
I used to oogle that ad every time it appeared in EGM. But for as much as the mail order catalog was asking for it, I could buy at least five or six used games. To a tween on a short budget, those games were infinitely more valuable.