I'm not sure how it will do. It really depends on how far Nintendo and Capcom are willing to go in terms of marketing. If the game is just dumped in the market without much fanfare like of lot Nintendo games up to this point, it will probably sell at a moderately. Word of mouth would be it's only fuel. While word of mouth had a big influence in past generations, games that had to rely on it this generation have for the most part have sold from fair to poor. Actually, GTA3 maybe the only thing I've seen this generation that has defied that reality.
I'm hoping that Joe gets the star treament though. Impressions so far have painted it as an exceptional title. On top of that, it has an appealing, hip style that can certainly be tapped into for the pop culture appeal. It also helps that comic books and super heroes are cool again. They are so many good things going for the game, and so many ways in which the game can be promoted on, it will be a shame if it meets the same fate as other great titles this gen that had no hype or fanfare surrounding them.
There is hope though. Nintendo's has started doing some agressive advertising lately for games that are far off in the furture--an unsual act from Nintendo. I'm hoping it's sign that they are getting serious about marketing, which can only bode well for something as cool as Joe.