I have been playing the shit out of a game called Control. Apparently it was GOTY in 2018 and they have 2 DLC's out for it. Just blown away by how good every aspect of this game is, from the cinematics to the voice acting to the actual gameplay.
I've been tempted by Control for many of the reasons that you list, and I actually bought it (without installing) a year ago. However, I've heard that it has "dynamic difficulty scaling" which is a thing that I utterly loathe as a matter of principle, and I have not had time to dive in and explore this. Have you observed this in your play through?