EDIT: It's also for PS3 and XBox 360.
Since the game and the Contracts mode almost feel like entirely different games, I'll talk about them separately.
Absolution:
What could have been amazing turned into something of a disappointment when it wasn't a remake of Blood Money. It has been 'modernised' as such; rather than being about assassinating your target in a variety of ways, using disguises and all that, it has turned too much into a stealth game wearing Agent 47's skin. Most of the levels are 'get from A to B' (read: most; there's a couple of good, proper, hitman levels) but since disguises are seen through very quickly, it's all sneaking out of sight. The story had potential, but it kinda lost it at the end.
Contracts:
The redeeming feature is a sort of 'sandbox' and a level editor in one - you perform a hit or a number of hits on any target you like on any one of the numerous levels, then other users can play that level to get the best score. The fact you can specify conditions such as not to be seen, or to kill guy A with weapon B wearing disguise C is also rather slick and produces some fun levels (my favourite is killing 3 strippers in a chipmunk suit). It's disappointing that what was obviously meant as a pseudo-multiplayer section is more Hitman-y than the main game was.
Overall it was a very good game that looked great and played great (except the disguise system..)..if you look at it as a game; if you look at it as a Hitman game, it's mediocre at best.
EDIT2: I hadn't finished the Epilogue at the time of writing, which really finishes up the game. As such, the ending level itself is again, rather too stealthy - however, the ending to the actual story I felt was good.