From my experience, most of the men nowadays like their wife as:
聰明/叻ge女人 in front of their friends/ families/ work .... => so that they have 'face', and don't need to worry about their wife 'being trap by others'.
However, they like a 蠢 wife in their family (when close the door) and they can feel they are very 'important' and 'big' in the family!