A new beta release for the Steam client includes scoped-achievements.
Achievements can now be split into game mode specific, DLC specific and seasonal specific achievements.
In theory, this will now allow players to achieve achievement completion, even though they're not interested in the multiplayer aspect of a game.
I've already seen (almost) this exact model with RetroAchevements subsets and it is indeed an improvement. It's not just about having organized achievements, but mastering a base set and skipping the grind set is a nice touch. (They also do multi sets, glitch sets, challenge sets, etc).
RA is a bit strict on guidelines though, like all achievements being single player unless in a multiplayer subset, etc, which would be a good model for games with multiplayer modes that go defunct. Too bad I don't see many developers going back and making that adjustment, though.