Dragon Age: Origins. Not sure why. I was a big fan of Mass Effect already, and of story heavy RPGs in general, but I stopped this one pretty early on and sat on it for several years. Needless to say, it stuck the second time and now I’ve played it and the other Dragon Age games multiple times.
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.