How can anyone mention anything except Grand Theft Auto: Vice City, amazing sound track!
My top soundtracks of all time are the Baldur's Gate series and Transport Tycoon.
http://users.tt-forums.net/jfs/
The X series had some nice atmospheric music as well.