If you liked RA2, check out the DeeZire mod
here. It's been long hailed as the "only RA2 mod you'll ever need". It's like an unofficial expansion, it's that good. It brings out a lot of hidden and scrapped units from development, and adds a lot of original content. It's even more balanced than the original game, and greatly enhances each nation's individuality with more units and abilities. All the new units and structures are in the same Red Alert theme as well. Two of my favorite Soviet units are the Iron Fist and the Oktober Sub. The Iron Fist is a subterrainian mobile war factory; it literally burrows underground and can pop up anywhere on the map and start deploying vehicles. It also has a decent rocket launcher on it which makes it fantastic for guerilla warfare. The Oktober Sub is a sea to land attack sub, firing one large cluster missle at a target at once. It used to be able to take out a construction yard in one hit, but it's since been balanced to take several. They recharge slower than the yard can be repaired, and you can only build one to limit the imbalances. Oh, you also get to do fun stuff like train Navy Seals. >:-D
Only downside to the mod is that it will not run on 2000 or XP unless you have the Yuri's Revenge expansion. It's simply an engine issue that wasn't resolved till the expansion, nothing could have been done about it.
I'd also check out the ProGen mod for Generals and Zero Hour, made by the same guy, on the same site. It's basically following the same kind of idea as the DeeZire mod, same themed units and balance fixes. Also poke around on the forums as well as Google for other Generals mods, there are some great ones, especially this really sweet Star Wars mod that I'd like to try.
------------------
Bassoon, n. A brazen instrument into which a fool blows out his brains.
Bassoon, n. A brazen instrument into which a fool blows out his brains.