The cover pretty much sums up what the game is all about. It's been deemed as "gun porn" because the guns are the stars.
It's a insane FPS for Xbox and PS2. This is easily the most intense FPS I've ever played and has some of the best graphics as well. The best part is 99% of the enviorments can be destroyed. The only bad things are there's no multiplayer and the story is pretty weak.
I kind of regret buying it because I beat it in under 6 hours (I only completed the main objectives and there are tons of of secondary ones).
It's definitely worth a rental over a weekend though, no doubt in my mind.
I give it an 8/10.
You can see some gameplay footage here