Neverwinter nights 2 is one of my favorite rpgs ever made, gog sells the new and still has the origional which is from the early 00s.
It has so much classic dungeons and dragons in it that its the closest ypu can get to many of the stories from the dnd boom of the 80s.
If you want post apocalyptic how about wasteland 2. Its turn based from 2014. The game is wonderful though so id say give it a chance. The characters that join you are great with some really unique flavor. Its a grity rpg in a dark world yet some how pulls off being light hearted. It also has great music and voice acting.
Mass effect andromeda, its semi open world but story driven. For me this one is way better than the origional trillogy. You play an explorer trying to find your place in the world for your self and humanity. The story has many twists and turns. The comat is fun and the world is very sci-fi and just blasting around in the vehicle listening to banter is fun just in itself. To me this game is a step up from the trilogy, that to me is just another solider story. Though its well done or at least 2 and 3 are, for me ME is just better all around. Besides there is nothing cooler in scifi faming yhan the mysterious Andromeda Vaults. It also goes on sale bundeled with dragon age iquistion for 10 dollars from time to time!
Go with playing an explorer, and play sara over scott. She fits the game far better. Though i also think fem shep is better in the trillogy due to Jen's amazing voice work. Her VA is what kept me going in the first. But Sara just works and fits the game so well, and her banter and quriky emotional relationship with her AI sam is something wonderful.
Lastly, maybe give banner saga a try. Its a turn base, survival, visual novel that is truely unique. Its a nordic story that deals with death, loss and betrayal. The game play is also very unique as it goes agianst the bormal mow everyone down one by one and instead you engage armies and weaken characters in a game of attrition. The story is a huge strong point and your choices really shape how the game goes and plays in the harsh un forgiving great snowy north.
You cant go wrong with any of these all are in my top 20 games of all time going back 30 years of computer rpg goodness.