This is known as "perfectionist paralysis." When the bar is set too high, the fear of not meeting one's own expectations becomes so intense that the brain chooses not to start the task at all to avoid potential failure and feelings of guilt.
In the short term, yes, due to the high quality of work. However, in the long term, it often leads to burnout, difficulty in delegating tasks, and conflicts with colleagues from whom the perfectionist demands the same impossible level of excellence.
Genetics play a role in shaping temperament, but the decisive factor is usually the style of upbringing. If parental love was "conditional" (praise only for success),a child learns to link their self-esteem exclusively to flawless results.