I know this is internet blasphemy, but HL2, although it was pretty much one of the most beautifully, gracefully and artfully executed single player games ever the first time through, it has the replay value of three-day-old lasagna from Olive Garden.
All cold and dried out.