The 16 bit console war had two serious contenders in the US, but one had a glorious rise and stupendous fall