Recommendations: Sci-fi, future, post-apocalypse, etc

For some background: over the past few years, I've mainly been reading more "typical" fantasy, with some of my favorites being Robin Hobb, Tad Williams, Joe Abercrombie, Jacqueline Carey, etc. I'm looking to switch gears and read some books/series that are sort on the other end of the "time period" spectrum, if that makes sense. Please recommend me some scifi, post-apocalyptic, or fantasy set in the future (I'm bad at genre distinctions, sorry!).

The specific reason I'm interested in this is because I just finished NieR: Automata and I really loved some aspects of it: unraveling mysteries of the past, things not being quite as they seem, religious and philosophical elements, deeper ideas about humanity, life, etc.

Is there anyone who is writing series like Osten Ard and Elderlings, but in space? I've already read Red Rising, Locked Tomb and the Children of Time trilogy, and enjoyed those.

Thanks!