Oh, yeah, it's definitely not the best game around, nor the best shooter. It's just a lot of fun to hose people with the heavy bolter or to burst-jump after a scared opponent, then corner him and chop him to bits...
BF3 on the other hand (beta, w000!) is awesomeness times 2... but 'the being shot in the head' when just spawning can get frustrated. Space Marine offers the opportunity to go at it like a mad dog and not get shot with a single bullet.
But I agree, we need another kind of of 40K game. Something inquisitor thing would be awesome, so would be an RTS like Supreme Commander but with EPIC, oh buy we need an RTS on that scale asap... titans, superheavies, thousands of troops... gimme gimme! Or an even larger scale, like Star Wars Empires thingie, with interplanetary spaceflight/battles and rts planetside. *fall of his chair frothing at the mouth and trembling*