Red alert 3 is awful for PC too. So dont worry about hte port being bad. Lags a lot on PC and terribly imbalanced.
starcraft 2 is coming out and will be awesome.
Valve games and others built on the source engine will continue to be played extensively (current ones like Left4Dead were ported but are better on PC)
DotA games and remakes (Heroes of newerth, league of legends) are new games which are commmanding a lot of attention in the PC user players minds.
MMO's will continue to be PC Centric, WoW still has a lot of life left and there is a new one Aion which is played by a lot of people.
In my opinion, console games are far worse, I have a ps3 and an xbox and I can think of only very few games worth buying. They are Street fighter 4, halo 3, madden 10, nhl 10, tiger woods, 10, metal gear solid 4, gta 4, asssasins creed, cod4/5. Now this may seem like a long list, but when you look at it and think that these are they only ps3/xbox exclusives worth buying, thats pathetic. Game dev's put out hundredds of games for consoles, but most of them are awful and wouldn't hold my attention 10 minutes.