I don't feel qualified to speak on behalf of womanhood, but would say don't worry much about being erect, we are looking at the whole body, and just look at it yourself, do you like it? Like if it was a picture of someone else.
Also if you have someone who likes the way you look, let them take pictures, it makes a difference.
Absolutely clear minded, stone sober sex is my favorite, I've never really enjoyed it as much while drunk or on any drugs except for one time coming down from LSD had an amazing time but I think that was an outlier.
Generally speaking I prefer to feel everything, and I feel it better when starting out clear of mind. And awake, though again, one exception - one time my ex caught me at exactly the right level of sleepiness, I felt like all the inessential layers of personality had been peeled back and it was amazing, relaxed but so intense.