Snake Eater comfortably takes this for me. It's really the only example I can think of where a developer created one of my favorite games of all time, but pretty much everything else they've done, even within the same franchise, leaves me fairly cold.