Common(?) misconception? No. Unless they are Bene Gesserit no one thinks that.
Prior to the Akin kerfuffle, it was a not-uncommon notion. It seemed plausible to a lot of lay people (and apparently to Akin's physician) because we hear so much about how stress and trauma affect people in so many other ways. Once it became a huge controversy, of course, things changed.