The correct answer is soporific.
The word soporific comes from Latin, where sopor means sleep. So soporific in English relates to something which tends to make people drowsy or sleepy. In this case, David felt very sleepy during his long trip to his parents, and even though he loves his parents, he hates the voyage.