To the naked eye, there's a difference. However, if you are like most, and you fail to pay attention to detail, you're not going to see a vast difference between a PS3 installment and 360 version. In fact, your Madden's, GTA, etc. will look identical on both consoles.
The difference will be Sony's exclusive gaming experiences.