Unreal Tournament and Deus Ex both come to mind. Alexander Brandon was involved in both and his work is absolutely amazing.
If we talk specific singles, though, it's Morrowind (Nerevar Rising), Control (Take Control), and, recently, Baldur's Gate 3 (Raphael's Final Act). Morrowind's tune is so ingrained in my mind that it's my to-go whenever I get my hands on a keyboard.