I've seen many videos and it looks brilliant! But when I found out that the game was only available for console, I was really annoyed. I thought the same about LA Noire as well. I don't own a Xbox or PlayStation you see, which makes me even more annoyed. I need to stop being so cheap and buy a games console. :P
It is brilliant. It took me by surprise at how incredible of a game it is. You can't go wrong if you pick up a PS3 since they have better exclusive titles than Xbox. Throw in the Uncharted series, God of War series, and Infameous series and that should be all the reason you need.
(even though it isn't a PS3 exclusive, getting a console gets you access to Red Dead Redemption - another incredible game that should have come to PC).
By the way, LA Noire is out on PC now in the event you weren't aware.