Single player needs a really good story and not senseless questing/levelling to try and create game play out of nothing.
Multi player games can give people more freedom to explore in an open world and interact.
I get board quickly if there is a big open world and with endless quest for no apparent reason.
Counter strike is always better playing multiplayer, played a lot of BF3 multiplayer and never started the single player campaign.
Football manager can be played in multiplayer mode but it's boring waiting for players.
The multiplayer type where everyone is in the same room - not a fan of online multiplayer.
Playing FIFA for example, the best part is doing something spectacular and making fun of your friend, trying to look at their control when they're taking a penalty, all that jazz.