I had real trouble getting into the game when it first came out. Took me like 2 years, or even more to get back to it and man was it worth it. I think the major difference was all the bug fixing that took place, the QoL changes, and of course, the DLCs. I still think it can be hard to get into the game if you are not familiar with the W40K universe and don't like to read a lot, but these kind of games always had their specific audience.
About the contents of this behemoth, the game really is huge. Vast main story that got even bigger with all the DLCs being tightly knit into it and pulling you in different directions. Really complex character building, which you can multiply by sizeable number of companions you have to think about as well. To be honest, it was even scary and intimidating at first. You simply don't know what to pick and how to build the char and I recommend learning a bit before spending the points. However, if you go with the ideal builds, the last 2 acts of the game can become too easy even on higher difficulty settings.
One should address the "side" activities as well. So...besides actually playing the game CRPG style, going through the locations, talking, fighting and basically deciding the fate of the expanse, you have to do few additional things. Space exploration with travelling between the systems and the planets with the manual creation of actual warp routes, space combat and your ship progression (new skills, new equipment etc), colony management with research projects for each, progression of the individual factions that you can sell your cargo to and then buying super cool equipment and more. Its just, a lot of content if you know what I mean :)
What the game needs is actual way how to experience the DLCs without having to restart the game. Not everyone has the time for multiple 100hrs+ playthroughs just to experience 10hrs of new content. Also, the last act, and no new game+ actually makes all of its otherwise cool loot and cargo completely useless. Having an option to return back after finishing the game and maybe completing some side stuff would be great indeed.
After 150hrs in it, I still have so much to learn and see for the first time here, its just that big. If I had more free time, or if you do and you love 40K, give it at least 1 playthrough. Its worth it.
