StingingVelvet: The interactive movie one? Damn that was terrible.
There was a supposedly good survival horror X-Files game on consoles but I don't think it ever came to the PC. I could be wrong though, I didn't pay a hell of a lot of attention.
Actually, it was really pretty good for a FMV adventure.
What upset fans (and reviewers) is people had assumed that in an X-files game, you'd be playing Mulder & Scully rather than them simply being cameos. As I recall, Mulder/Duchovny had maybe 5 minutes in the game total (if that) where as Scully/Anderson had a bit more after you actually managed to locate her.
I still play it from time to time just for the acting and the interaction between the agent you play and the detective chick.
Now, if you want godawful, you want the PS2 "X-files: Resist or Serve". The adventure/autopsy sections with Scully were ok, but that game just blew; especially the badly implemented "survival horror" with Mulder.