In case you haven't seen it before you can read Sid Meier's thoughts on Red Storm Rising and his other games in this excellent
Gamespot article
Subsim member Weps was actually working on an RSR remake but his site has not been updated in a while - check it out
here