That's an easy one: nope! All the best people I've worked with have struggled with not feeling good enough while simultaneously doing stand-out work.
Personally, I'm not stranger to this feeling. I've recently been hired into a new (well-renowned) tech company and wonder how that happened / whether or not this company made a mistake hiring me. The only way I can reconcile this feeling is to try and do my best at my new position, within reason, while trying to maintain a healthy work-life-balance that allows me to avoid the biggest detrimental effects mentioned by the article.
I don't think this is a self-fulfilling prophecy per se. I think the only danger that can result from an 'imposter-syndrome hire' is that they may burn themselves out easily if they don't find their footing in a new ground / new position and leave sooner than a "normal" employee.
Somewhat true of our industry.