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.
I also like how the only sci-fi conceit the book asks for (besides the antagonist aliens obviously) are the engines which are right on the edge of the theoretical maximum.
