I for one want to make them more significant than fetch quests.

I do however like the idea that they encouraged you to explore undiscovered places.

Maybe they could give you a mission to kill a boss and after you kill the boss you could get a trophy

and mount in jorrvaskr and have everyone in that hall comment on it as they walk past it or

praise you, something to make it more significant and worth doing, ego stroking!

I would be happy if they just provided actual written directions in my journal instead of forcing me to turn on my quest marker in order to know where I'm supposed to go. That one addition would go a long towards making me love Radiant quests.