The soundtrack of Tyrian 2000 proves that MIDI/AdLib music can still sound good:
The guy who composed it, Alexander "Siren" Brandon, also did the soundtrack for Unreal Tournament '99:
In terms of more recent games, the soundtracks for DOOM 2016 and DOOM Eternal are an absolute blast: