Some of the quests result in very very good items (the belt from the Catacobs blood collection comes to mind). Some of them result in neat house furniture items for decorating your apartment. They all result in decent exp and a good amount of AA exp (there have been examples of players leveling 20+ levels on nothing but collection quests, though these situations are extreme). They are all "worth it".