I bought it for the PS3 and the gameplay, graphics, and campaign are amazing. This is probably the most accurate 40k game to date. My favorite part is the smooth (yet violent) transition from shooting to assault (both offensively and defensively).. now I know how the little model space marines feel on the tabletop when the are being charged by a horde of orks lol.
Also weapons/tactics/enemies in game function pretty much exactly like the tabletop, I haven't got a chance to play multi-player yet but am definitely looking forward to it after I finish the campaign.