This was one of the better video-based graphical adventure games out there. It plays like an interactive episode, and from what I remember, it actually slots into the continuity since the writers were involved from start to finish. I hope you enjoy it!
The one to avoid is The X-Files: Resist or Serve for the PS2 which wanted to be Resident Evil with some X-Files branding slapped on it. It's not terrible, but it's definitely only for hardcore fans who can overlook some obnoxious gameplay elements.
It definitely sounds like they were careful to slot it into the continuity. It also seems like they spared no expense with regards to production costs.
Yeah, there's very little left un-exploded by the conclusion.