Not seen mentioned yet, but Homeworld (1999).

The transition from the opening cutscene to the game proper scored to Agnus Dei (Adagio for Strings) by Samuel Barber really set the tone for the thing.

I don't remember much else about the soundtrack, but that one piece stuck with me.