You might enjoy The Expanse book series! There are several world-building tangents that delve into exactly this area.
I'm thinking (no spoilers) specifically of how Ceres, having been spun up to provide artificial gravity, becomes a destination for expecting mothers trying to avoid complications associated with low-G.