That's actually the time period when I started to fall in love with game music. I'd download MIDI files of songs from 16-bit games. On most setups, they sounded quite bad. But in MIDI software that supported the AWE32's soundfonts a lot of them sounded incredible.
Gravis Ultrasound (?) falls into the same category for me. Really interesting and capable hardware that didn't penetrate the market enough to warrant significant investment by game developers.
And once 16-bit/44KHz audio and powerful enough CPU's became common, the need for hardware accelerated audio generation for games really diminished. It's all now logically pretty similar to the DAC section of a SB16 with a bunch of software driving it.
It's nice that the level of capability is as high as it is, but I do miss some of the unique hardware designs from that era.
I never owned a GUS, but I seem to remember most games having support for it. It always seemed to taunt me from the game's installer.
Or maybe I'm just thinking of demos and modtrackers. A lot of them used to require a GUS for sound, I think?