I haven't read any of the books you mentioned in your post so I am not sure if these are up your alley or not, but the last 3 sci-fi books I've read have all knocked it out of the park for me:
- Seveneves - Neal Stephenson
- Spin - Robert Charles Wilson
- Project Hail Mary - Andy Weir
You can tell I am a sucker for all books dealing with the impossible vastness of space 🤣