There are some in books, like "The Infinite and the Divine" but sadly they are bestowed the curse of all books put in the gaming settings: "no changing the setting" so even if you read the above quite fun story about 10000 year spanning rivalry and gigantic and important quest, just from the world-changing plans you already know from the start that they will fail.
I yearn for one day actually interesting 40k plots, which are probably not forthcoming
There are some in books, like "The Infinite and the Divine" but sadly they are bestowed the curse of all books put in the gaming settings: "no changing the setting" so even if you read the above quite fun story about 10000 year spanning rivalry and gigantic and important quest, just from the world-changing plans you already know from the start that they will fail.