I enjoyed the first two God of War games (have actually yet to beat the second one), it was the visuals that attracted me to the game. I have always loved Greek mythology, so that was another reason I was drawn to it. Ultimately, anyone going into it for the mythology will be disappointed, as there is actually no attempt by the creators to actually follow the real mythology, rather they take massive liberties with it just taking chunks they thought were cool and tossing them in where ever they feel like (which I still enjoyed well enough).
In the end, it is a very visually pleasing buttom masher filled with plenty of puzzles of varying difficulty levels (most of them being not at all). But it is also extremely gorey, so anyone who dislikes gore in their games won't care for it.
There is also a fair deal of female nudity in them, the first two both featuring a sex mini game that earns you extra points (it is really lame, the camera pans away, and you pretty much play dance, dance revolution with the sounds of your character grunting and the women groaning. I felt it the whole thing was in pretty bad taste and did absolutely nothing to help the game out. Just added to please the large protion of the games audience who have never actually had the opportunity to do that in real life). The Gorgons and the Sirens (who, interestingly enough dwell in the desert, far, far away from any source of water) go around with their breasts hanging out, as do some of the temple priestesses.
Originally, missing out on God of War III and Metal Gear Solid 4 were the only reasons I had to think twice about buying a 360 instead of a PS3. Since I have still yet to beat GOWII or MGS3, and have kind of lost interest in both series, I am glad I didn't let those factors motivate me too much.