Depends on the game.
Some DLC are equivalent to the expansion packs of the 90s where they add new content, new areas, and let you continue the story.
Others are just small cosmetics, or single new classes.