A few for me:
I had family living in Spain. Journey is nearly 1700km. Journey is done in one go - whilst family sleep and enterain each other, I drive. The going is great. This is bliss. Returning is awful, especially because the end of any long journey is tiresome. This one is particulary bad, as it feels like when you "nearly home" you've still got 200km to go. Not alot, but after 1500km ...it's long. This is hell.
My eldest daughter lives with her mother, 65km away. Usually I pick up my daughter from school, but occasionally have to pick up from her mothers place. One time I did this journey, and just as I was within 10km of her place, the radio station played Chris Rea's Road to hell. Thought it was fitting (not from my daughter POV of course.)
Last one. A mixture. When returning here from a visit to the UK, I love coming home. That's the bliss part.
The hell part is purely as a result of the road network.
From Calais to here, (not so far - 450km) the journey can be broken down into little segments, with each "segment" defined by motorway changes, city ring road, country border. After that final motorway change, when I feel I am nearing home and usually starting to feel a little tired and relaxed, I spot a sign "Luxembourg 159km" and then adding on the exta 40km for me, the near home feeling suddenly dissipates. Happens every time.

I know the sign is there, but still it gets me.