If the game has both, but is mostly centered around multiplayer, then the single player is just a way for me to get prepared for the multiplayer mode.
But that all just depends on which game. Like with Halo 3, I played through campaign and once I felt prepared, I jumped right into matchmaking.