Heres a quick screenshot comparison of The Elder Scrolls V: Skyrim on PlayStation 3 and Xbox 360. While the PC version is the best, the console versions visuals are more similar than you might like to think.
Read more to see the screenshots.
Click on an image to enlarge.
From the screenshots you can see that sometimes they look the same with no differences while other times the PlayStation 3 looks better than the Xbox 360 version or vice Versa. If you can’t get it on PC and you have to get it on console then obviously get the version for your platform. However if you have a PlayStation 3 and a Xbox 360 then get the game for the console you care the most about achievements or trophies for.