I would mention a game probably very few even played or enjoyed.
Legendary - Very fun single player campaign, has puzzles and until you finish the puzzles, enemies respawn infinitely, so it kinda gives you something to do even if your stuck, I usually hate both things when they happen in other games, but both combined gave me a real sense that I had to play with haste cause no matter were you were, you knew enemies were coming soon (and making it worse, werewolf enemies!).
Advent Rising - One of my top 5 games of all time, would almost buy a new Original Xbox just for that game.
Other mentions:
Fracture - Love this game a LOT.
Lair - Even the motion controls worked great for me.
Gun - Consider it better than all the GTAs combined, loved it and got 100% on PS2 and PSP version, working on 100% on the 360 version.