That said...I am someone who generally detests multiplayer. I do not like playing games with others and it usually is more frustrating than anything
Why and how come?
Well, you have to both want to play it the same way or else there's going to be a lot of frustration. That's one thing that rubbed us the wrong way about
Diablo III: I wanted to explore every nook and cranny and he was getting bored and annoyed, but if we just rushed through the levels I'd be bored. Two, it's almost always competition even if it's co-op, like about getting more gold/kills/items in that game, and I don't like competing with people. Three, I am not very social and like being alone. Four, if the game has a story it almost always ruins it by killing it as a personal experience, which is fine for games that are made for multiplayer but not so much for games that have it as a main-story addition.
I don't know, I've just never really had more than a couple good multiplayer experiences. The only game I consistently want to play multiplayer is
Super Smash Bros., and then I like to mostly do it co-op. I feel bad if I keep beating people over and over on it, and I'm more likely to do versus if I get to put crazy handicaps on myself or if we do crazy game settings that make it insane like what we dubbed "Norfair soccer" where you could die at any second if you aren't watching everything at all times. Five, if you're not there in person you have to either type, which takes you out of the game and is annoying, or speak into a headset or something which I find kinda annoying and bothersome because I don't talk a lot. But playing without either means there's no coordination and it's really impersonal and not a whole lot different from just playing with a computer, except for the fact that you can't tell it what to do.
Then, sometimes, co-op makes things too
easy, like, again,
Diablo III, or even
Borderlands, or, to a certain extent,
Super Mario 3D World.
So yeah, there are only a couple of games that have ever reached the perfect scales of everything to make me enjoy them with others, but they are few and far between.