Some non-military sci-fi authors I am familiar with are Arthur C. Clarke (specifically 2001, 2010, 2061, and 3001, as well as Rendezvous With Rama)
Andy Weir (The Martian, Artemis, and Project Hail Mary)
Cixin Liu, author of Remembrance of Earth's Past (AKA Three-Body Problem), however part of the second book is military sci-fi as Earth builds a fleet of ships to fight the Trisolarans, but then the Trisolaran response to the fleet is unique and not very military.
Ben Bova's Grand Tour series. However, some of the books, in my view, are hostile to people of religious faith and some may not like that.
Brandon Q. Morris Ice Moon series
Kim Stanley Robinson's Mars Trilogy (Red Mars, Green Mars, and Blue Mars) about the terraforming of Mars and the society the develops there. However, Robinson definitely is a liberal and sees Socialism as being superior to Capitalism. He is 'woke', but certainly liberal, and some may not like his stories for that.
For movies there is Ad Astra, Interstellar, and one unique film, Outland from 1981 starring Sean Connery. It's, more or less, High Noon in space. Sean Connery is the new Federal Marshal on a mining site on Jupiter's moon Io.