John - very good question.
One of the most exciting things I've experienced in golf was at Pacific Dunes. The first tee is up by the clubhouse, and you have 18 green, the shuttle busses, guys milling around, etc... It's really not unlike many other courses from an audio perspective.
But BOY - when you first hear the roar of the ocean... WOW! If that doesn't get your juices flowing, nothing will.
Conversely, walking up 16, away from the ocean is different. The roars become quieter as you head home. It's a little sad.
Similar thing down at 13 green / 16 tee at ANGC. Those darn cardnials are VERY loud - their song echos through the pines and down into the valley. It adds a lot to the experience.
From a more everyday experience, we have I-76, the PA Turnpike to the right of our 5th hole. There are some berms, but it's noisy. Honestly, I don't even notice it anymore. Likewise, our 17th tee (about 1.5 to 2 miles to the north) is about 1/4 mile from a shooing club. They shoot skeet with shotguns and they too are loud. Again, I don't notice it anymore, but guests do. I think it's pretty cool - it adds to the countryside feel of the place.
But there are some spots where you're in very quiet surrounds.
It's a really nice ebb and flow.