but any actual social/cultural changes of actual significance are unfathomable or even scary.

It’s why I fucking love The Expanse. The Belters feel absolutely distinct, with a unique culture and language that would develop from being exploited, poor, and forced to work in space without any support. It’s one of the few sci-fi series to actually have a thought about what culture would look like in space and how even the (relatively, in scifi terms) short distance between Earth and Ceres would still contribute to massive social changes.