Earlier quoted context omitted.
Yes, some excellent magic tricks work even better when you know how they work, especially if they’re the kind that’s based on putting in ridiculous amounts of work or skill/practice. Penn and Teller play a lot with that idea, for example.
Dani DaOrtiz is one of the best at that. He sells instructions for all his tricks, but he's so good at performing them that they still feel like magic even if you know what he's doing. His appearance on Fool Us¹ is a series of excellent examples of that. He palms a card onto the box, and Teller's reaction when he misses it happening is astonishment because it's such a simple move to spot but done so well Teller misse…
I went to a local show of a magician doing the levitating woman where he'd pass the rings across the length of her body to show no strings attached. however, his showmanship was so bad that his assistant was struggling to keep the trick going. when I saw her wince, the secret became very obvious. there she was being very acrobatic suspending her body vertically with just the strength of her one arm, but he took so damn long that she grew tired and her arm strength gave way. she recovered very quickly, but just not quick enough to keep the secret. I felt bad for her as he would more than likely blame her rather than admitting his own bad showmanship and not realizing her effort. It was at that point that I realized just how important the "assistant" really was.