100% this. It's about replayabiliy. Some games have it in spades as the game elements involve interacting with other players making each play through experience somewhat unique. Others are very dull to play again. Single player offline games are quite rare these days for this reason, the last big one I can think of was half life 2.
There are plenty of very successful single player games these days... but exactly like you said, they tend to involve the player interacting in unique ways to make the experience more varied. Grand Theft Auto and Red Dead Redemption, Elder Scrolls games, Far Cry and Just Cause. Even Mario and Legend of Zelda have gone this route. Linear story-driven single player games are niche, but open world, player-driven, interactive, "radiant AI" style games bring the feeling of a living multiplayer world to the single player experience.
