Just another so-so RTS game
The "Command and Conquer" series is frankly getting a little tired, but the basic elements o' fun are here; neat graphics, an easy interface, and some pitched battles. The missions are reasonably imaginative and the cinematics are neat. It's a fun game.
You can get the same fun out of any one of three dozen games, and there are much, much better RTS games out there. Red Alert 2 offers nothing interesting in the way of multiplayer games; it's really not suited for it. If you want truly outstanding RTS gameplay, "Total Annihilation" and "Dark Reign" are so far up and beyond the norm that there's really no reason to have Red Alert 2 on your hard drive.
The Bottom Line
It's okay, but not worth the effort.