Yes and no.
It's more about satisfying the user intent versus article length. And it primarily depends on the keyword.
For a simple question that can be answered in a few paragraphs, I'd go for a 1000 to 1500 word article.
For a detailed guide like how to start a business, 3000 to 5000 words will be sufficient as you may need to cover multiple sub-topics, FAQ section, recommend tools/services, etc.
There are certain topics that require crazy long article-length too (5000 to 10000 words) but those are rare and most often, you wouldn't need to add this much content.
A general rule of thumb I follow is to check word count for first page results and add extra 500 words to the highest word count article. And this extra content wouldn't just be fluff but some extra sub-topics or questions.
My reasoning behind this is that if other factors are equal, chances are Google might give a small boost since my page is providing more value.
Hope it helps.