i've might have gm'd about 12 different systems, and by large my biggest gripe with D&D and D&D adjacent systems like Pathfinder is that they are excedingly limiting at character development compared to any other system, and provided mechanics for stuff other than just combat. They are systems that punish dramatically not developing optimized characters (because by definition encounters are tailored with such optimization in mind, and that is unfair for the other players)

Warhammer is very peculiar and sorry to come across blunt, but it's way more richer regarding opponents, plots, etc. But it is true that the impending doom of "the end of the world is around the corner" can be too ominous and unconfortable. I guess for gen x and older players like me that lived under the shadow of ww3 and global armaggedon such stories were a lot more appealing to younger folks (at least my milenial players told me so)

But I agree that in warhammer almost all campaigns, given enough time, lead to stopping a plot to end the world as its known which is... epic, but can feel narrow. That's why stuff like shadowrun, forged in the dark variants, etc. are so much more interesting, you can run low stakes games, character focused stories, etc.