One can only hope it would look like the mods, and one would think that would be very feasible. The basic structure for the games is already there, all they need to do is give it a new paint job. I'd live the opportunity to play GTA San Andreas online with my PS3 with no hassle. As you know GTA San Andreas can be played online on PC, but for someone that's very used to GTA controls on a PlayStation controller it takes some getting used too. Another pitfall of playing on PC is that I have no clue how to use the mods that improve vehicles and other facets of the game.
Another great thing is that they finally announced the Liberty City stories will come to the PS3 adding a new layer to the single and multiplayer games with additional weapons, vehicles, and interiors.
Color me excited for all of it.