I wouldn't personally want that, but it gets me thinking that I wish the frob distance for locks could be customized by the player via a mod tool. Maybe the mod adds a new slider in the in-game menu. 100% is standard default distance and you can't set further out than that. But you can move the slider to, say, 25% and that would require you to be much closer to the door/lock to interact with it.
For instance, if I want to do a playthrough where I wish to need to be much closer to the door/lock, then I could adjust the slider to my desire
It would create additional challenge and tension that is missed because we can currently lockpick from far away shadows sometimes
Hopefully it is possible to make the slider for just locks, and not every object?
Do you think this would resolve the issue you bring up in OP and would it be an attractive solution, I wonder?
I'm tempted to throw door frobbing into this slider setting, too, but I think that'd cause too many problems. E.g., Setting slider to 25% might make the act of swinging doors open a pain as your player model would probably get in the way a lot