Our favourite sex positions are variations of face-to-face, but with my legs over his shoulders, rather than around him. One involves him being basically in a "push-up" position, and in the other, he has his feet on the floor or bed and is in a squat-like position. Neither involves him putting his weight on me, although his weight is not a problem (he only outweighs me by about 15 pounds, even though he's 5 inches taller). He is lean and muscular, and I also love to watch the muscles in his arms and shoulders as he holds himself above me and pounds me.
I think the major appeal of face-to-face positions, in addition to the stimulation, is about connecting with your partner via eye contact, as well as being able to look down and get the visual treat of seeing his cock move in and out of your pussy.
Plain old missionary doesn't excite me that much, however. Variations of it with my legs together and his outside, or our legs "scissored" with one another can be quite wickedly stimulating at a slow pace. But our gold standard is definitely rough sex with my legs in front of his shoulders.