The quests and guilds are rather dull, unless they make a picking random flowers guild than you being guild master will never make sense. There are good quests sure but none of them have any real impact. Slay Alduin and most won't even notice a difference. Have the NPCs react to what you do even if it's major milestones. But don't worry mods will fix everything wrong with the game.