Some popular detective spy games include 'Clue,' 'Codenames,' 'Spy Alley,' 'Scotland Yard,' and 'Sherlock Holmes: Consulting Detective.' These games offer thrilling mysteries, challenging puzzles, and exciting gameplay for both children and adults.