Got to say, having dated someone who was severely depressed and into self-harm, that no, we don't expect perfection in women.
However, there are people who Imagine they want a perfect woman (the multitude of men who crush on celebrities supports that) but when the actually meet someone who they are compatible with, they get over that.
So, all in all, I'd find perfection rather boring.