Oh how happy I am to meet other mamas who experience sleepgasms while pregnant...not that I mind them, but I did feel like a hormonal freak as I've never met anyone else who has them due to pregnancy. I do, I do! Last week it was Jon Stewart...interesting...one time (when I was pregnant with DS) I dreamt about buying massage oils and orgasmed from that...strange! That was also (with DS's pregnancy) when I was told by a doctor not to have intercorse or orgasms because I was having bleeding (for four weeks). I couldn't help it though. I kept waking up in the midst of orgasms...I stopped worrying after I decided that my body would not be doing this if it was harmful to my baby.
I think orgasms are more plenty while pregnant...I wouldn't say sex is better since it gets more challenging as I get bigger.