mercs mode > the actual game. the campaign gets a worse rap than it should though. It's not as well paced as RE4, the story isn't as good, but the core shooting gameplay is there, which is enough to carry it. It's also replayable as fuck.
Except the rail shooting/el gigante part....that was some crappy shit.
edit: console versions are definitely not better looking than uncharted 2.