Sound not playing at all when entering attenuation range.

Probably you need Virtualization Mode “Play When Silent” for both the wave and the cue.