There are little to no long term consequences to a quest. Mostly, it is a difference in dialog that results. So pick what you want or the role you play wants.

There are some pre reqs you can skip with certain passives and dialog choices.

But you will always get the reward and exp no matter what path you take.

There is one quest that can give you a couple of skill points or not depending on your choice, but that is telegraphed by the game. It is one of the final Mage Guild Quests.

You can wind up with slightly different endings to quests, where a given NPC will be happy/sad/alive/dead etc.

But the rewards you get are equivalent even if not identical. One not very useful green item vs. some gold instead for instance.

Except for that one quest in the Mage's Guild line it's essentially roleplaying stuff only.

Mage Guild's Last Quest, is only one that affects your character, as you can gain 2 skyshards or not, all the other "choices" don't really matter

Even if you go with what seems like the "bad" choice, it still works out "for the best" in the following dialogue.