The first console I ever bought, it was hyped as a threat to the PlayStation, then mocked as a flop. But now, as it marks its 25th anniversary, it’s looked back on with misty-eyed reverence