I was recently "burned" with Pathfinder: Kingmaker, which is still in rough shape, after all this time (I think there's some fuckery going on with the publisher, where Owlcat can't update the game anymore), so I'll definitely give it some time. Rogue Trader might also be in a similar boat as BG3, where the later Acts have more bugs, since those weren't in any playtests or betas, but that's just what I read.

I'm also fine with not getting everything, so that isn't an issue. All I know of 40k is basically through various memes on the internet, throughout the years, so basically nothing.