...do they just give out a higher sP amount, or are the items worth more too?

Just a random musing that popped up in my head and now I have to know, lol.

it depends on the quest. Some give out more sP, others items of a higher rarity and some can give out special items.

I've definitely gotten both or one or the other from weekend quests. Just luck of the draw it seems