When I was a kid I was only allowed to play educational computer/video games. The only exceptions to that were 2 games that came with our Win95 computer (when we got the computer it came with a little case full of software/game cds). One of the games was redline racer, a game where you could race motorcycles on pretty cool (for an 8 year old) tracks. The other was G-Police, a game that took place in an outer space colony built inside domes on the moon Callisto. You played as a guy who joined the government police to find out what really happened to his dead sister. The entire game play was executing missions piloting a flying fighter craft and the story was told/discovered via radio transmissions and cut scenes every few missions. I probably put hundreds if not thousands of hours into playing that game over and over between 8 and 10 years old. I actually found redline racer a few months ago on an abandonware site and got it to run on my computer, but the only install options were French, German, and Spanish, none of which I speak. I installed the Spanish version and was surprised at the fact that I could still remember/navigate all the menus. I haven't found G-Police anywhere or ever heard of anyone else who knows it. Part of me wishes I could find it and get it to work for nostalgia, but the other part of me knows that it's going to look like a bunch of boxy awful graphics and I should not taint my happy memories.
G-Police was the poster child for new texture streaming effects over the AGP bus. It was one of the first games (if not the absolute first) to feature animated billboards.
There was also a Playstation version which may be easier to find.
Nanosoft...
There's a line from one of the early missions where you have to scan cargo to find something being smuggled, which I've always remembered for being so state the obvious enthusiastic. There are four to scan, and after unsuccessfully doing three they say "three down, one to go, it's got to be the next one!"