Usteros
Warlord
There are some guys here who redo units already made. Maybe one of them could change the hat and camoflage color on the Soviet to make him look modern Russian.
Sandris and me have been told already - modern Russian units will be followed sooner or later; problem only in the many actual Sandris' projests, but...
I know the Russian infantry is more of a Cold War unit than a "today" unit. I guess modern is a relative term, considering that Civ III is an epic game. I do plan on making another Russian in the future, whcih will have a more modern flavor.
...but it is not improbable that You will be first here. If You will need some actual info about Russian (and not only Russian ) military history of last century, I will be glad to help You as possible.