I second both Arcanum and Fallout 2. Both Witcher games for me, although in the second one I almost got bored with Flotsam because it was not very easy to run and just in general is the least enjoyable part (don't know if this is a spoiler, but things get really good in the next chapter and the next starts out fine, but ends far, far too quickly. I debate whether too long or too short is preferable.) Non GOG, but Fire Emblems: Sacred Stones, Path of Radiance, and (same boat as Witcher 2) Radiant Dawn. Generally Zelda and Metroid games do this (for Metroid Zero Mission and Prime 3) and EDF: 2017. Oh, and any Soul Calibur game, those are really good. Unfortunately, I will get either bored or out of the mood for some games I think are really good and leave them let sit for long whiles. Oh, Medieval II: Total War is a game which I always go back to, sooner or later.
Pseudoman: - Putt-Putt Goes to the Moon
Might just have to get that sometime...
Edit: While I'm on the subject, the space ship shooter mini game from Spy Fox was really good.