For the coming week MAG won't move any hardware (well maybe PS3 will go up 1 or 2 %, or perhaps stay the same, but I wouldn't be at all surprised to see PS3 drop on MAG week). ME2 will help 360 sales hold steady, or even cause a small spike (maybe as much as 5%). If ODST could cause a 15%(?) lift the week of its release ME2 can surely give 360 a 5% helping hand. However that may well be bringing forward 360 sales that would have happened anyway but in subequent weeks, which could lead to a following week drop by the same or bigger %.
There are still a few titles out there that will cause a substantial hardware spike. I think FFXIII will spike PS3 and 360, possibly more so PS3. GT5 (perhaps not in America) will generate a decent spike, and perhaps a moderate sustained lift over a period of weeks. GoWIII will spike PS3 sales for sure, I'm pretty confident that there are GoW fans still sitting on the PS3 sidelines waiting for this game.
I can't speak for 360 or Wii because I don't know their game libraries or histories so well, but there are surely some titles that will spike HW sales in the very least.
Still I generally agree that there aren't likely to be any games that truly cause an upshift in baseline console sales. Only console pricing can do that now. Despite all the hype around certain peripherals I don't think any peripheral on its own can upshift console sales.
“The fundamental cause of the trouble is that in the modern world the stupid are cocksure while the intelligent are full of doubt.” - Bertrand Russell
"When the power of love overcomes the love of power, the world will know peace."
Jimi Hendrix