Literature

You've already had a recommondation for most of what I would suggest to you, but I will happily second the suggestions for the Revelation Space series by Alastair Reynolds, the Teixcalaan series by Arkady Martine, and the Imperial Raadch/Ancillary series by Ann Leckie. All have excellent worldbuilding and tell stories that depend heavily upon how their characters interface with the worlds they inhabit.

A little pulpier in tone, but still very well put together, I'd suggest as well the Wayfarers series by Becky Chambers, and especially the Locked Tomb series by Tamsyn Muir. The latter is a bit more fantastic space opera as opposed to some of the harder sci-fi you've mentioned, but Muir knows how to write a setting that is absolutely dripping in gothic horror, and still take you on an emotional roller coaster fully of highs, lows, and humor as you read it. It seems to be a bit of a love-it-or-hate-it series from the other conversations I've had about it, but I love it and I'd be remiss not to suggest it.

I'd also suggest, if you're not averse, dipping your toe into the fantasy genre as well. There's a broad range of authors there who have done excellent work building fantasy worlds that are structurally deep and compelling, and have many science-fictional qualities. Along these lines I'd suggest Robert Jackson Bennett's Founders trilogy, or N. K. Jemison's Broken Earth trilogy -- though, fair warning, both of these broke me in the end emotionally. Worth it, though!