It's just boring and tedious with a few precious exceptions, especially when it's not your first run and you know there will be no payoff in the end.
There's too much to do for an area of that size and no point in doing most of it. Only companion quests if you care about them, but even those feel rushed in their implementation.
I personally lost interest in the main plot the moment the Emperor was introduced.