My all-time favorite game is Space Hulk... Doesn't matter what edition. It has all the surprise, action and tension you could want in a board game plus it makes the players feel like there is the tension that you are actually on the Space Hulk itself.
My second favorite game is Flash Point: Fire Rescue...
Followed by Mordheim: The best skirmish game in the history of skirmish games!!!