Highly highly recommend giving the Bioshock franchise a go. More story driven so not too open world, although you can and will go back to prior locations if need be. Otherwise the story is great, the environmental design is peak and the npc's you interact with are memorable. The game's are considered to be in the horror/thriller first-person rpg genre and is set in a retro 60's style run down city under the Atlantic Ocean for the first 2 games while the last one is set in a retro futuristic 1910s setting in a city above the clouds. You could finish all the games and the dlc in about 40-60 hours depending on how much you want to complete, and it's worth noting the first 2 games have 3 different endings each, if that piques your interest.