Yeah, it looks nice, but of course it's nowhere near as nice as the trailer mockups. It's kinda too bad, it's saying "Ok, we KNOW it looks like it's 5 years out of date, but we're hoping you won't notice once these trailers that have no relation to the real graphics suck you in and get a purchase".
It's sadly the habit now of all games. Graphics sells, so if you have a release for consoles you do your best to hide the fact that it looks like it's made for last-gen systems. Because it is. The designers do the best they can but they're still limited to an itty-bitty run space, many times moreso for PS3.
What I kinda wish is they would make a game that would not only scale right, but be
ported clean to the PC with far better graphics capabilities. As well high def graphics and shaders and the whole works.
Of course, the big reason most don't is the time involved.. you're now making two separate versions of the game, and the man-hours goes up, for a market that most publishers consider abandoned at best (mostly because they abandoned them!)
Ah well, at least we have mods, and those can fix up some of the issues, and do what the developers don't have the time to do.