Faithful: ...I never cared for the swearing in the game. It got a bit tiring to her what's her name say over and over, "watch my a**" and other lines.
Other than that aspect I remember this game as a lot of fun, but I never finished it but I got quite far into it.
Is there a good ending?
Do you mean good as in satisfying ending or good as in everyone lives happily ever after? There are total of 4 endings: american or soviet victory and alliance ending for both sides. I liked Alliance endings (more on american side) the most and it's probably the best or 'true' ending. I also liked American side generally better both story and gameplay wise. Soviet side felt more restriced in both character choises and what you could do in missions. I also did not particularly like Soviet main character (I fail to see how alliance ending could possibly happen on Soviet side).
Arabian/Legion story arch could have been interesting but unfortunately there's no such campaign.
Hopefully I did not spoil too much :)