Sabotaging yourself in single player makes no sense (and is entirely optional in multiplayer), but competitive questing will result in there being more options and quest solutions, and NPCs reacting more to your characters as individuals than as a group, more replayability, etc.
