There’s a lot of different ways of starting and stopping sounds. For each of them, the attenuation setup seems to vary somewhat.
I found this works:
Use SpawnSoundAttached, or SpawnSoundAtLocation, and have the attenution setup like this:
for close and
for more distant.