Ghost of Tsushima is one of my comfort games, but I hate replaying the end of act 2 because of the emotional toll.
In Devil May Cry 3, the Nevan boss fight and backtracking through the rearranged tower after it's activated are just tedious.
Another user said the Fade section of Dragon Age: Origins, but I'll go with the Deep Roads. Everything you learn in that section is fascinating, but man, I just want to see the sky again and you're down there for a while.