Fred is missing for the entire game. The plot of Scooby-Doo! Night of 100 Frights (2002, PS2/GameCube/Xbox) centers on the gang investigating Fred's disappearance from a haunted mansion. You play as Shaggy, Scooby, Velma, and Daphne searching for him.
He does not appear as a playable character or NPC until the final cutscene (rescued).