I dunno man iv played a lot of Warhammer franchise games as well as the tabletop and I can't remember any narratives about townsfolk going about their lives or something similar. It's pretty much all death all the time.
Maybe that stuff is in the books for the hyperdorks to read but I'm not aware of it and I doubt the vast majority of people familiar with 40k are either.
Ignore the queers, they're full of shit.
40k humanity is an amorphous blob little better than the tyranid living in a mega socialist, Ingsoc, war communist hell where you work your quota and then you die.
It is to live in the cruellest, most brutal regime imaginable. For there is no peace amongst the stars, and whatever happens you will not be missed.
As for the old colourful art, Blanche had an appreciation for the medieval illuminations. That's why with the boxarts everything was so resplendent and larger than life. Replace Angels and God with tanks and titans.