That's why detectives are so often protagonists in general, but especially in scifi. The other common approach is the fish out of water, where you introduce someone not used to the scifi society at all and use them as an excuse to explain why the scifi is the way it is. That one tends to have much heavier reader self-insert tendencies though, so writers tend to shy away from it.
Detective novels in space can still be good, and much better than the current crop of Hollywood garbage. I'm still quite bitter about what Amazon did to The Expanse. First legit sci-fi we get in years, and they devolved it into "muscle bound hero shoots aliens with laser gun" within one season of acquiring it from SyFy.
Amazon didn't pivot from a detective story to an action story. Abraham and Franck (aka James S.A. Corey), the authors, did. After the arc from the first trilogy of books wrapped up.
Well then I don't know what to think now. This seems to be a problem for artists in general. You spend your entire life coming up with an incredible work, and once its released to the world and everyone agrees that it's incredible, now there's all this pressure to followup. The second story arc comes off as just completely sophmorish in every possible sense of the word.
One thing that stuck with me for many years is Joss Whedon saying that the Serenity flies at the speed of the plot. It's more important to understand how people interact in situations than it is to know how fast the ship can go. It can either get there with plenty of time, just in time, or we can't make it - and how that affects the people.
Consider that a lot of the best Star Trek stories are merely allegory for our own struggles. Some of them are pretty thinly veiled (The half-black-half-white people hate the half-white-half-black people) but even a kid can pierce that veil and understand and say "Oh... racism is stupid"
I think the "____ in space" effect is probably more related to poor writing then a specific component of the genre.