How about The Expanse or The Martian? They’re both relatively hard sci-fi that focuses mostly on our own solar system.
The Martian tells the tale of a man stuck on Mars and his ability to survive on his own whilst those back on Earth figure out a way to get him back. Both the book and the film are great so you can’t go wrong with either.
The Expanse covers more of the local system. Earth and Mars are on the brink of war, whilst others live out near the asteroid belt, Jupiter and beyond. It goes a little sci-fi later on but it’s an inherently human story that has some great characters living in a time when space travel is still dangerous but achievable by humanity. It starts a little slow but ramps up brilliantly and has a nice conclusion that wraps everything up pretty neatly. You’ve got 9+ books, a 6 season TV series on Amazon Prime, and a newly released TellTale video game, all of which are well produced and worth investing time in.