I think there's a flaw in this want, which is that you don't know what "realistically designed" means. I've never been on a large space station, and aside from academic or artistic ventures, one has never been built.

The same is with wastewater treatment plants, etc. And, if you're targeting realism, size might be an issue.

That said, there are games that are thoughtful about this, such as doorkickers or heist.