I'd also like to recommend the novel series "The Expanse". While not entirely accurate, at least the start of the series deals with a lot of the near-future lim

I'd also like to recommend the novel series "The Expanse". While not entirely accurate, at least the start of the series deals with a lot of the near-future limits in space travel: lack of gravity and the consequences thereof for humans, acceleration, radiation etc. And in the new TV-Adaptation there are fascinating little details like sparrows flying/hovering in 0.3G inside a tunnel inside an Asteroid (Ceres) with an artificially induced spin.