I've heard that C&C3 is better overall but I'm glad to hear that it's a fun game its own right.
It's been so long since I played RA2 I don't recall if units were this weak, but you may well be right. I have to say I take back what I said about super-weapons. Each faction has a number of special abilities they gain access to as the missions go on, and while not super-weapons in the traditional sense, they fulfill many of the same functions. One of the soviets for example is a Thor's Hammer, basically they destabilise orbital junk and bring it crashing down on the enemy. Setting aside the hilarity of the amount of times you can do this during a campaign, it's actually surprisingly effective. And traditional super-weapons in the later stages of the game give you what is an absolutely vital ability to break a battle-line and allow you to breach your enemy's defenses, especially if you've got to launch attacks across water.
C&C3 is probably the better game overall, but I do so enjoy the RA universe.
Personal favorites are Tim Curry's hammy acting, the fact that Dasha (your Soviet Eva lady) wears low-cut PVC, the Allies mission victory emblem that wouldn't look amiss as a playboy cover, and JK Simmons who is becoming a legend in his own right for his hilarious portrayal of the US president.