My favorite is probably Diablo 2 LOD if we are talking about composed originals.
A close runner up may be the THPS games like 1-4 + Underground which really capture the action of the game and get you pumped. But that's more like a compilation.
I do like stuff such as LoZ OOT and Resident Evil 1-2. RE Orchestra is pretty dope.
Halo 1, 2, and 3 always brings the nostalgia too.
Heavy Rain is a really tragic game and soundtrack if you want to get some feels.
Death Note is an anime that I really like the OST of. Some of the simple repetitive vamps get me interested in pulling out instruments and getting lost in the trance.
There's just so many choices... Posting a song from RE Orchestra that captures some of the creepy mansion vibes and a nice uplifting orchestra. Does it sound like Jurrasic Park or something? That's a good soundtrack too lol.