Without DLC packages? It depends on the players. Dawnguard is a lot of scripted story that add few narrative material to elaborate your own story. It is about listening to a character with an AI that shows heavy limits telling her story.

If some players keep playing the game, it is probably more because of the vanilla content which allows to replay the same game with a different angle due to the riches of the open world.