Do you have any examples?
Compared to what came before, “Newer” games span a vast range of genres and styles, including retro games that probably have what you’re looking for.
I have yet to experience the phenomenon you’re referring to, I’m rarely putting on my own music or turning off in-game music.
A bumpin’ soundtrack can be just as immersive as ambiance, what ‘fits’ really depends on the game.