The two are very different, most notably that the Autobot and Decepticon campaigns are split across two games instead of one in the DS version. Compare the gameplay and story of the console version to the DS version.

"When there's gold feathers, punch behind you!!"“Critics who treat 'adult' as a term of approval, instead of as a merely descriptive term, cannot be adult themselves. To be concerned about being grown up, to admire the grown up because it is grown up, to blush at the suspicion of being childish; these things are the marks of childhood and adolescence. And in childhood and adolescence they are, in moderation, healthy symptoms. Young things ought to want to grow. But to carry on into middle life or even into early manhood this concern about being adult is a mark of really arrested development. When I was ten, I read fairy tales in secret and would have been ashamed if I had been found doing so. Now that I am fifty I read them openly. When I became a man I put away childish things, including the fear of childishness and the desire to be very grown up.”-- C.S. Lewis

The Wii Cybertron adventures also has different story than the PC/Xbox/DS versions and fills in a few more gaps, its more of an arcade shooting gallery type thing than an FPS, but like I said it fills some holes in the story, I don't have a Wii but have been watching some TF games I don't own, like the Wii advntures and movie trilogy games (especially walkthrough for DOTM) that are pretty interesting to see, especially DOTM about what happens to some of the other Transformers before the movie.

The coward desires revenge but being afraid to die, he looks to others, maybe to the government of the day, to do the work of defense for him.