Armidex definitely works within a few days. Erection quality is somewhat different than libido(mood). I have had spells where I could get up but had trouble with climaxing and might lose my erection, and other time just had trouble getting it up. I believe there is some truth in having your E2 within the sweet spot.
A little high seems to be better than too low. I have found that I function best between 10-20, and mine doesn't go above the ideal 22 ever, but I've heard other people say up to 30 is still ok. When mine is around 20 I function great in the bedroom, under 10 I'm in trouble.
I would expect it take a week or more to start affecting mood (brain function), but you might wake up with a stiffie.