Hogwarts Legacy completely averts this trope. It's probably worth a play.

I think it's primarily successful because of its use of uses smaller, mostly linear environments. It's also swath with plenty of shaders & animations that react or trigger on player position—there's always multiple things happening on screen, not just one idly spinning fan off in a corner somewhere.