The New Steam Version (included alongside the original THQ release) has all the multiplayer components modified to use Steamworks, as the original multiplayer servers are no longer available. Company of Heroes: Opposing Fronts and Company of Heroes: Tales of Valor count as DLC and do not require any extra downloads.
The OS X release of the game, it includes the Opposing Fronts and Tales of Valor expansions.
Note that multiplayer is not included.
Use the -nomovies command line argument.