I didn't know there was 2006-2008 era? I have two fav games from that time - Hitman Blood Money and FlatOut 2. There have been no good Hitman and Flatout games since so.
Deus Ex (2000) - a game that pushes the boundaries of what the video game medium is capable of to a degree unmatched to this very day.