Sometimes the CIC goes bad, other times it's the circuit board that goes bad. There are several different N64 CIC chips, none interchangeable as far as I know. The 6102 is the most common.
There are 5 known CICs for NTSC N64 games.
NTSC:
CIC-NUS-6101
CIC-NUS-6102
CIC-NUS-6103
CIC-NUS-6105
CIC-NUS-6106
The CIC-6102 chip is considered the standard NTSC security chip. The vast majority of releases use this CIC, so they won't be specifically listed here, for it would be a list of over 250 games. If a game is not on the below lists, it uses the CIC-6102.
The following game uses CIC-NUS-6101:
Star Fox 64
The following games use CIC-NUS-6103:
1080º Snowboarding
Banjo Kazooie
Diddy Kong Racing
Excitebike 64
Ken Griffey Jr's Slugfest
Kirby 64: The Crystal Shards
Kobe Bryant in NBA Courtside
Major League Baseball featuring Ken Griffey Jr.
Paper Mario
Pokémon Snap
Pokémon Stadium
Pokémon Stadium 2
Super Smash Bros.
The following games use CIC-NUS-6105:
Banjo-Tooie
Conker's Bad Fur Day
Donkey Kong 64
Jet Force Gemini
Legend of Zelda: Majora's Mask, The
Legend of Zelda: Ocarina of Time, The
Mickey's Speedway USA
Perfect Dark
The following games use CIC-NUS-6106:
Cruis'n World
F-Zero X
Yoshi's Story
Hope that helps.