There are tons and tons of good campaigns still being made. FPS games are really the only ones lately that don't have really decent stories to them. But that's because people usually play FPS games -for- multiplayer.
Online socialisation is crazy-important these days, so of course most games now are going to have some sort of multiplayer added on to it. I don't really have a problem with it. In the end, it's just a bonus option. If I don't like it, I won't use it. I'll play singleplayer (or even split screen) exclusively, just like I did with games way back before multiplayer was even in existence.
My only real issue with multiplayer is when an obviously singleplayer-focused game adds on a multiplayer experience, and the campaign gets much less focus on it, and turns out way worse than it would have been. An example would be like if, say, 'The Last of Us' had a worse campaign because they added in the multiplayer aspect. Luckily it didn't happen, but that would have hugely annoyed me - Resources get split up too much that the campaign doesn't get as much attention as it would have, to the point that it turns to crap.