Snover, you haven't played Dune 2? It - NOT Warcraft 1 - is the father of the realtime strategy (RTS) genre.
Yes, Dune 2 has digitized sound. You have to select Sound Blaster or Sound Blaster Pro to hear it though. There's also a patch that includes an enhanced setup program you can get for it that lets you pick separate hardware for music, musical sound effects, and digitized sounds. I suggest using it and configuring as follows:
Music: General MIDI (or MPU-401 or Sound Canvas or whatever it says)
Musical Sounds: Sound Blaster Pro (or Sound Blaster or Adlib because they sound better on an OPL chip than a MIDI synth for some reason)
Digitized Sound Effects: Sound Blaster Pro (or Sound Blaster)
If you can't get digitized sounds then it's probably not Dune 2's fault. Check your drivers and test with other DOS programs, or - if all else fails - boot into pure DOS mode and install some DOS drivers for your sound card (if necessary). DOSbox also runs Dune 2 decently (it had better, since they themed their web site after it), but I found some quirks.