The problem with solving puzzles to improve is that in a real game, nobody is going to lean over and tell you that there is a brilliant winning move hidden in this position. They aren't allowed to do that.
So in my opinion, one of the key differences between a strong player and a mid-ranked player isn't so much calculation ability as situational awareness... which includes the ability (gained by experience) to sense either danger or opportunity.
Several months ago, whenever those challenges would come up on his YouTube channel while reviewing games of super grandmasters, I would never be able to see and find the winning move, I felt very dumb, but after a lot of practice, including puzzles, and games, I started to see them more and more and could get it right almost all the time.
I wonder if there's an approximate range of chess rating or elo, to being able to find the winning moves in chess super GM's games like that?