I really really really liked the theme music and all sound design in the Red Alert 2 and Generals Zero Hour games. Those were excellent, to the point I'd listen to the theme alone when working or driving.

The Hotline Miami series and Katana Zero really stand out to me. Hollow knight and Persona are also fantastic.

Elite Dangerous is still the GOAT of sound design IMO. That game would be nothing without it's sound.

assetto corsa competizione

or really any quality racing game. its almost like 50% of my enjoyment

For a unique take... The music and background sounds in Kenshi. Music is so sparse that when it does kick in, and how it kicks in, is just really unlike any other game.

For overall sound design Prey (2017) really nails it. The stealth mechanics are also included in sound design so when you get spotted or escape there's intense auditory cues that track with the thriller/sci Fi horror vibe of the game.

If you go into it expecting a first person shooter though you'll be disappointed, it's an immersive sim for sure. Shotgun sounds really good though and there's an experimental weapon called the Q beam which has a phaser sort of sound as it fires. Also really cool.

Also, Elite Dangerous has incredible sound as well. Guns sound alright but you won't be firing them on foot as much as in space most likely.

The soundscape and music of Inside is godly. Honestly I think half the game's atmosphere is the audio.

I don't care for the Warhammer universe, or Tactics games all that much. Tactics game Warhammer 40k: Mechanicus held my attention for far longer than it should have thanks to its incredible sound design.

Max Payne 3. The soundtrack is amazing and blended perfectly into the game.

The modern hitman trilogy had some really good sound design from my experience. Definitely recommended with a good pair of headphones. Realistic but also crisp.

spoilers for the game hi fi rush but it has hands down the coolest transformation https://youtu.be/cU5utimmtkg?t=92