There are quite a few that fit the description.
-Castlevania Lament of Innocence: While the camera is a *****, the voice acting wasn't really good (Though this was on the PS2, so by comparison it was pretty damn good), and it could get unfairly difficult, It still had some of the best music in the series (which is quite the claim indeed), the controls and combat were damn good, and it truly had the atmosphere nailed down. I have not finished Lords of Shadow, yet but it reminds me of Lament of Innocence more than any God of War or Dante's Inferno.
-Prototype: I really hope this game gets a sequel, it was so much fun to go around New York and cause havoc, plus it had a very unique and interesting way of filling in the story through the Web of Intrigue. The first few hours I played it are even more fun than the first few hours of Vice City, which says a lot.
Finally,though I could go on for a very long time, there's the Legend of Zelda: Majora's Mask. I LOVE this game, it may even be my favorite game of all time. Every thing from the character transformations, the darker tone, haunting music, and the interesting characters that are actually integral to the game instead of just standing in one place and repeating a line of dialog. If I could play just one game from now until the day I die, this would be it.