Aroused / Horny - gained automatically, or from seeing sims woohoo, or from watching Kinky telelvision
Woohoo - Post-woohoo moodlet. Woohooing for the first times gives a strong 24-hour mood boost.
Raped - Negative mood unless the sim's a Masochist (by trait or LTR)
Creampied - Positive moodlet gained after vaginal sex.
Horny Curse - Moodlet can be only made by a wizard/witch. The "victim" gains the moodlet and accepts every woohoo asks until a woohoo session has been made (it end at every kind woohoo stage starting the session, so beware of non-linked stages.)
Wet Panties - Moodlet gained when a female sim, wearing panties, has one of the "aroused" moodlets.
Recent builds have added alcohol-related moodlets which make your sim more likely to autonomously perform certain actions.
There are also bestiality-related moddlets, gained after sex with an animal.