Well, the best ambiance mod I've seen is the one simply called ambiance.
I was planning on making a client mod that would implement different forms of ambiance as the API progresses. At first just music, then later sounds that change depending on one's direct environment.