How about this one:
Space Crusade?
Space Crusade was pretty great back when. It's the game that got me into WH40k.
It's 1-3 players, turn-based, each player controls one 5-man squad from a chapter, the chapters have some specializations, like Blood Angels are slightly better at close combat if you equip them for it, Imperial Fists heavy weapon marines can move further. There's a campaign with about 15-20 missions, winning missions lets you use more wargear and more orders with your commander (like Fire! which let you fire twice in a turn), losing the commander I think reset the amount of orders or something like that, while squaddies were replaced without penalty. You could equip 3 heavy weapons, assault cannon (could distribute hits to take out a lot of enemies depending on total damage die roll), rocket launcher (AoE) and I think plasma rifle which hit everything in a straight line as far as you could see. The last marine had a normal bolter. The commander could have either combi weapon, bolt pistol/power axe, or power sword which made him harder to kill but then he couldn't fire, just fight hand to hand iirc.
Nice variety of enemies, some weak gretchin, Orks, super dangerous gene stealers and androids that had a pretty dangerous rifle. And then of course the Dreadnought. Mission objectives varied to some extent, but didn't really affect gameplay all that much, except the composition of enemies. From the top of my head you had Seek and Destroy, which was to find some console and pew pew it, but the dread was always in that room. One mission was to eliminate all genestealer eggs, and some other one you had to open the airlocks and escape back to your pod. The chapter that completed the primary objective got extra credit, so you could play it sort of competitively, or even take each other out if you wanted to. We mostly played it co-operatively because it was too hard otherwise.
Can't remember if I ever got it working well on modern machines.
This current game is obviously hard to judge, but yeah, extremely low budget by the looks of it? I always preferred space crusade to Space Hulk: VOTBA.
