BG3 is a great example simply because there is so much content you can miss. I’ve put 1300+ hours into it and I still see things I haven’t seen in any prior playthrough. Granted they aren’t large story things or quests anymore but still, even the little stuff adds up.
Have you tried the Star Wars Jedi games? Fallen Order should run fine on your machine and possibly Survivor too but that might be a little much for your rig. \
They’re both wicked fun games that award exploration. I would call them souls-lite not soulslike since they are much easier than something like elden ring or sekiro (that doesn’t mean they are easy though).
Play Baldur’s Gate 3. It’s enormous. It’s difficult and the turn based combat is something you’ll have to get used to but it’s incredibly fun and deep.
I’ve put 1300 hours into the game because if you get bored you can just start a different character and try the story from their perspective. There are dozens of ways to complete every encounter.
Good news is if you have the DLC you can skip the first act. The DLC start puts you in front of the Church in Pacifica after fighting Placide.
I like Cyberpunk a lot but replayability is shallow like you say. Sometimes I just boot it up to punch npcs though. Make a gorilla arms build and go ham. It’s pretty cathartic.
There’s a danger in any game where it might be largely designed and marketed to be one thing, and then has lengthy mandatory sections where it becomes another.
This is the only issue I have with the cyberpunk 2077 DLC. Most of the game is an open-world action rpg. Then all of a sudden depending on your choices in the DLC you can end up in a mission that is basically Alien: Isolation survival horror. You go from being a powerhouse that can destroy pretty much anything in the game and shrug off missile hits to being hunted and unable to kill what is hunting you. It was super fucking annoying the first time I did the DLC because I hate those type of games. Great DLC except for that small part.