nebulous

you can play dark crusade's campaign which I think I don't have to detail how it is
or get soulstorm and add U.A mod if you want
warhammer 40k space marine is good
dow 2 retribution is aright, you can add elite mod for idk what, although population is capped i think you can edit it
Battlefleet gothic armada II is also very good

I haven't tried any of the battlefleet gothic games yet but i've heard ok things about the second one, not a huge fan of the naval battles of 40k but might tide me over until chaosbane comes out

My brother has it and all he tells me is how he eats ships or cuts them in half with Tyranids, I've tried it a bit myself and it's an interesting game to say the least
To be honest, If you want to play some 40k and just "relax" in the midst of a massacre, Dark Crusade's campaign offers good choice. Soulstorm with UA is good for just spending time annihilating each other

Also, I forgot, DOW 2 campaign actually is also very good. You might want to check it out

I've played all the DOW games and the ultimate apocalypse mod to death sadly, really been itching for another good game but Eternal crusade was a massive let down and everything else i'm not really interested in, hoping 2020 brings something good to the table

Welp, then I don't know what else. I'm on the same situation myself, I've considered checking out the tabletop. Or just smashing myself by reading books of 40K. Overall, I can't remember anything else. I think they released some games but meh, they're not so great from what I see

I play table top every now and then with an IG squad, looking to get another army soon from the new genestealer cult stuff, also reading a bunch of black library books, just want to VIDYA though man