Hm. This one is a bit tough.
Metroid Prime is one game that fits this for me. I love the atmosphere, music, and exploration aspects of the game, but I hate the artifact hunt and the high amount of backtracking. The controls are also pretty dated by today's standards. Getting into a fight with...