Its launch was pretty bad, and despite content being a little too slow and low-impact it has most definitely made a recovery.
Right now the game is definitely worth picking up and will net you a solid amount of playtime.
It's as 40k as it gets and probably one of the best video game translations of it world/aesthetics wise.
Combat is extremely fun and polished too, which is good cus you'll be doing a lot of it.