Definatly mafia, also its a fuckin great game. Hitman 2 also has a very good soundtrack (as mentioned above).
Though a very tight ambient soundtrack is super metroid, for the snes. You can get this winamp plugin and play varous old snes soundtracks if you want. All is here
http://www.alpha-ii.com/snesmusic/red.html