Alien/Expanse Style "Everyday" Hard Sci-Fi?
I loved Alien because it seemed very everyday... but in space, on a spaceship, in the future. I loved the Expanse too, though as soon as it gets too "hero" I get bored, and I also get bored of super powers. Also not a fan of space opera: as soon as i get a glimpse of cape or harlequin paving I'm.. yawn. I have enjoyed military sci-fi because it also has that everyday element of tactics etc.
Last series in this vein I REALLY loved was Allen Stroud's Fractal Series: Fearless, Resilience & Vigilance (I can't remcommend them enough, give them a read)