Well, it’s where I came down on the issue, which is why I put the descriptor “dumb” in quotation marks.
As for Covenant, TV Tropes does its usual bang-up job summarizing the progress of the Idiot Ball, and it’s passage downfield:
I think that in the original Alien the crew’s “stupidity” is much more “natural,” in that “space-truckers” on a bog standard commercial deep space tug are not suited, mentally, emotionally, by education, training, experience, or inclination, for dealing with the Xenomorph. Add in the “inside man” in the android Ash, working covertly against the crew, and I think the story flows quite naturally.
Likewise with Aliens, where the Marine’s experience and capabilities works against them; they dismiss/underestimate the Xenomorphs because, in their experience, no such thing existed, and they were (overly) confident in their technology and firepower. Hilarity ensues.
Alien3 and Resurection seem to repeat the patterns of the first two movies.
But with Prometheus and Covenant we have trained and skilled specialists, in their respective fields, scientists and such, who should know better than space-truckers, Marines, or lifers on a penal colony, yet do incredibly stupid, reckless, and irresponsible things anyway.
When they inevitably and all-too-predictably die by their own stupidity, I get a grim, smug, mildly annoyed, “I-Told-You-So” sense of satisfaction, and disappointment in the story.