Check out the massive communities built around strategy games like Civilization - I think SP games are doing well.
That said, IMO the social and community aspects are just icing on the cake. A game gains no traction unless it's a good game first. The community that grows around it are an accelerant for future growth, but will not exist at all if it weren't for a solid game underneath.