Max Payne is a classic. It was the game that brought slowing down time in a shooter to prominence. Of course, this mechanic has been done to death in games, and at this point, it is more of an annoyance in most games.