Two Days and Two Nights was just AWFUL! I think that the writers were trying to go for humor, but it was all so cringeworthy...and so NOT funny !I find it hard to come up with any excuse for his stupidity (and Trip's of course!) in 'Two Days and Two Nights', but to my mind the worst demolition job on his professionalism is the scene in 'Broken Bow' where he gets fixated on those butterfly girls and Travis (the ship's helmsman!) has to call him to order.
This was the episode that had to set out the stall for the show, and the Brit got put straight out there as a lecher who can't even keep his mind on the job in hand as soon as a few scantily-dressed curves come into view. The whole scene is skin-crawling to my mind. Did the writers deliberately try to play into stereotyped prejudices with this - and later with other 'weaknesses' - anyone else on board Enterprise have a phobia (Trip didn't like bugs, but that wasn't quite in the same class), and not just one allergy, but a string of them? I can't help but wonder.
He did, of course, display many sterling qualities: courage, ingenuity, loyalty, self-sacrifice. All of which are the reasons why I love him so much! He was the voice of conscience in the Expanse when the captain made the decision to steal the Illyrians' warp coil. But I remain convinced that at least some of the writers had very anti-English attitudes, of which Malcolm Reed was made the hapless beneficiary.
As for Broken Bow, my interpretation of the scene with the butterflies was that Malcolm was so intrigued with such a "foreign" species (I'm sure he was familiar with Vulcans, Denobulans and others that are on earth) - and he seemed intrigued by what they were doing, not just what they looked like. Whereas Travis had experience with exotic species and it probably didn't phase him.