technically they are already here.... albeit called something different.
nand flash storage and SSDs or even M.2 drives.
As something that will be sold along side every game copied on it, no. It can't make a comeback. considering how cheap discs are to make.
I do see m.2 SSDs coming with the next generation of consoles tho. Not only will 1TB nand storage be ridiculously cheap by then but the performance boost they could give consoles is too much to ignore. Going from the current ~150MB/s now to around 2GB/s is no joke.







