Sci-fi/ space exploration and disaster survival

I love space opera and exploration type books, but not ones that get into being mostly space wars. I loved all of Arthur C Clark’s books and also The Martian and Hail Mary. What books or book series fits that description? Also, natural disasters, end of earth type books where people have to save the [...]