I think it'll be a moderate success. Definitely no Fallout, Borderlands, RDR, etc. From what I've read, the game lasts about 15 - 20 hours with no MP. I can see the game having a problem with gamers renting the game instead of buying it.
One thing I've noticed on HD consoles is that the most popular games have a combination of accessibility, quality, & length.







