If anyone hasn't played the game Dune, it is definitely worth checking out - if only to watch a Let's Play on YouTube.
It's not really an RTS a la the more famous Dune 2, but a sort of adventure/strategy mix. The appeal, though, is just in how luscious it is. It's a bit dizzying, beautiful (remarkably so, for the era), and full of soul in a way that few games of the era were. The Adlib Gold soundtrack in particular remains an amazing work of art too: https://www.youtube.com/watch?v=gUfGyfbzl9k