So..... Tiger and I have something in common. I do not sleep on Ambien rather, I go into a very euphoric state, it is very surreal. I've even stayed up all night after taking one. While I have not had sex during Ambien, I could see where it might be pretty fantastic.
Needless to say, I did not take it after the first few times as it was useless for me in conquering insomnia.