Surprisingly, perhaps, it was a Protestant source that so far was most helpful:
Pastor Doug: Keep in mind, that’s the King James translation of that phrase ‘woman’; in our language it sounds almost derogatory—it sounds like a motorcycle biker talking to his motorcycle mama—hey, woman, come here. But we don’t understand that that word in Hebrew means ‘madam’. It was a term of respect. You know, Jesus said to the woman caught in adultery, ‘Woman, where are your accusers?’ Well, He wasn’t talking down to her.
He was actually addressing her with respect. So when Jesus said to his mother, while He hung on the cross, ‘Woman, behold your son’, ‘Son, behold your mother’, it was a term of respect. In our language—you know how terms change with every generation? Like, you know, fifty years ago you tell someone you’re happy and gay—it had a whole different meaning than it has now. So back in 1611 Woman was a term of respect.
amazingfacts.org/radio/bible-answers-live-question-archive/ctl/playmedia/mid/731/mdid/2420.aspx
Here is another valuable source.
The Protestant commentator William Barclay writes:
Code:
"The word Woman (gynai) is also misleading. It sounds to us very rough and abrupt. But it is the same word as Jesus used on the Cross to address Mary as he left her to the care of John (John 19:26). In Homer it is the title by which Odysseus addresses Penelope, his well-loved wife. It is the title by which Augustus, the Roman Emperor, addressed Cleopatra, the famous Egyptian queen. So far from being a rough and discourteous way of address, it was a title of respect. We have no way of speaking in English which exactly renders it; but it is better to translate it Lady which gives at least the courtesy in it" (The Gospel of John, revised edition, vol. 1, p. 98).
Further comments available at this site:
cin.org/users/james/questions/q087.htm