My kid has it for XBox and it looks fantastic. The cut scenes look like movies, the game has great depth, lots of characters, and a slew of really cool guns.
I can't play it for long because I get motion sickness, but it is really great game. There are a lot of gameplay videos on youtube you can check out. Its kind of like Grand Theft Auto in the old west, but in RDR if you pull out a gun and start acting up, the townspeople don't run away screaming - they pull out their own blasters.