Red Alert(1) from 1996 got a "soundtrack of the year" award. Initially I was puzzled by that. It has a few great tracks, but not amazing. Until you play the soundtrack in a loop. The tracks are very atmospheric and totally unobtrusive.
Another soundtrack by Frank Klepacki - Tiberian Sun - is also not something you would play on a concert. But it serves a perfect background, too.
Then I understood there's more to a great game soundtrack than very memorable tunes. XCOM2 soundtrack is optimized for short term, for trailers even. Red Alert 1, Tiberian Sun soundtracks are optimized for long term, to be loopable.
I need to get in touch with newer games, but I have very fond memories of Master of Magic, Heroes of Might and Magic 1-4, Magic Carpet, Dungeon Keeper1,2; Little Big Adventure. Those were definitely special and music was a big part of it.
From newer games I appreciate Rimworld. It may be inspired by country and Firefly, but it's something I'm happy to play on a loop.
Incidentally ambient music artists are some of my favorites. I love programming while listening to the British band Fluke (on youtube) or even Orbital. Even ayahuasca shamanic songs.