There are plenty of single player games with bad stories (Skyrim, I would say) and a few hugely social games with decent ones (for all its flaws The Old Republic had a few good plot threads), but to say that all games should be social in some way is just not true.