Did you ever play Alien Isolation?
That is exactly what you are describing.
I haven’t, oddly enough I will eventually. but to clarify a bit, I like the formula behind Colonial Marines. I just thought the implementation was garbage.
I essentially want the movie “Aliens”, but with no companions, or just the odd survivor here and there. No horde battles, and have the environment and audio provide as much, or more, tension as the visuals.